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
when I attempt to LOAD DATA INFILE the tab delimited field ascii file. ========= Field Type Null Default ====================================================== manufacture name | varchar(20) | Yes | NULL name | varchar(50) | Yes | NULL street address | varchar(50) | Yes | NULL city | varchar(20) | Yes | NULL state | char(2) | Yes | NU zipcode | tinyint(12) | No | 0 =========== Suggestions if i have the data types correct? street address has numbers and characters.
obliged, Stretch
--------------------------------------------------------------------- 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