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 version for the right syntax to use near 'FIELDS
TERMINATED BY '\t'' at line 1

why feilds term...  is wrong there?

thanks a lot...


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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, 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]