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
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
