Error load from Mysql

Open cscdtc opened this issue 3 years ago • 0 comments

Thank for developing the tool, it looks perfect for my usage but doesn't functional well while load from Mysql, I got below error:

TableName, RecordsFound, Extracted, RecordsIngested Column 'DATETIME_PRECISION' does not belong to table Table1.

at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at Excel_2_Snowflake.Form1.CreateTableMYSQL(String TableName, String dbName) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM schema_name.table_name' at line 1

at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at Excel_2_Snowflake.Form1.ExportTableMYSQL(String TableName)

Mar 04 '22 07:03 cscdtc