Español
English
Forum
Table Manager Support
Table Manager SupportForums
Public write access is disabled. Please login
Error message on creating a table from CSV 15.03.2014 16:05
An error has occurred.
1064 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 ')' at line 1 SQL=CREATE TABLE IF NOT EXISTS `VerO_brevets` ( );
Return to Control Panel
This is the table I pasted:
RecNum;NumDeBrevet;Lieu;DateOctroi;Validite
1;123;Louvain;2014-03-15;2016-03-15
What I am doing wrong?
thanks
1064 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 ')' at line 1 SQL=CREATE TABLE IF NOT EXISTS `VerO_brevets` ( );
Return to Control Panel
This is the table I pasted:
RecNum;NumDeBrevet;Lieu;DateOctroi;Validite
1;123;Louvain;2014-03-15;2016-03-15
What I am doing wrong?
thanks
Re: Error message on creating a table from CSV 17.03.2014 09:25
Hello,
When using create table from CSV fill table name and column names is needed. You should write table name and column name on each field according to mysql rules: [0-9,a-z,A-Z$_] (basic Latin letters, digits 0-9, dollar, underscore)
In error written in your post seems that column names was not filled.
Regards,
Moonsoft Team
www.moonsoft.es
When using create table from CSV fill table name and column names is needed. You should write table name and column name on each field according to mysql rules: [0-9,a-z,A-Z$_] (basic Latin letters, digits 0-9, dollar, underscore)
In error written in your post seems that column names was not filled.
Regards,
Moonsoft Team
www.moonsoft.es