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
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.