simple load query

2006-01-17 Thread kalin mintchev
hi all... 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

Re: simple load query

2006-01-17 Thread James Harvard
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,