Skip to content

Error load from Mysql #2

@cscdtc

Description

@cscdtc

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)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions