List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:March 6 2003 9:23pm
Subject:Re: syntax error 1064 ||
View as plain text  
In the last episode (Mar 06), Lou Ann Hammond said:
> 
> Hail,
> Below is the table that is generating the following error:
> 
> LOAD DATA LOCAL INFILE '/www/htdocs/car-list/admin/8_rows_dealerX_test.csv' 
> REPLACE INTO TABLE carlist_db.e_xoops_dealerX_cardealers FIELDS TERMINATED 
> BY '\t' LINES TERMINATED BY '\r' (manufacture name,name,street 
> address,city,state,zipcode)
> Error: 1064 - You have an error in your SQL syntax near 'name,name,street 
> address,city,state,zipcode)' at line 1

You have field names with spaces in them; you will have to escape them
with backtics:

  BY '\t' LINES TERMINATED BY '\r' (`manufacture name`,name,`street address`,
  city,state,zipcode)

-- 
	Dan Nelson
	dnelson@stripped
Thread
syntax error 1064 ||Lou Ann Hammond6 Mar
  • Re: syntax error 1064 ||Dan Nelson6 Mar