Code:
load data local infile 'D:/CITY/SAMPLE.TXT' INTO TABLE 'sample7';
I am trying to run this SQL code with MySQL-Front, but I always get a SQL syntax error. I want to reload my table with a different structure for the table, and not having any luck. I did the import this once before, but now I cannot remember how I succeeded.
I am trying to follow the books and the MySQL examples, but it doesn't seem to matter the order of various parameters, or which ones are added or dropped. I have tried many variations, and all get the same error message.
Quote:
|
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 ''sample7'' at line 1
|
Any ideas?
03-13-2007, 04:20 AM
SQL Syntax Error
Similar Threads
Threaded Mode