Your FIELDS clause is not in the right place: http://dev.mysql.com/doc/refman/5.0/en/load-data.html HTH, James Harvard
At 7:06 pm -0500 17/1/06, kalin mintchev wrote: > whats the problem with this: >load data infile 'stores.txt' into table useyourcash_sports_us (chain, >store, address1, address2, city, state, zip,web) FIELDS TERMINATED BY '\t' > >i get: > 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 'FIELDS >TERMINATED BY '\t'' at line 1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]