importing into MySQL giving error #1064
Posted: Mon Jul 21, 2014 9:49 am
I am trying to import and excel file that has been converted into Tab Delimited txt
and am getting the following error
[text]
MySQL said: Documentation
#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 'ProductID Product Producer Description Colors Size Price MinimumQty Discount Sto' at line 1 [/text]
the headers of the text document are
[text]ProductID Product Producer Description Colors Size Price MinimumQty Discount Stock UnitWeight Image ImageDetail catID[/text]
the table already does have content in
and am getting the following error
[text]
MySQL said: Documentation
#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 'ProductID Product Producer Description Colors Size Price MinimumQty Discount Sto' at line 1 [/text]
the headers of the text document are
[text]ProductID Product Producer Description Colors Size Price MinimumQty Discount Stock UnitWeight Image ImageDetail catID[/text]
the table already does have content in