List:General Discussion« Previous MessageNext Message »
From:Lou Ann Hammond Date:March 6 2003 7:53pm
Subject:syntax error 1064 ||
View as plain text  
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

Thread
syntax error 1064 ||Lou Ann Hammond6 Mar
  • Re: syntax error 1064 ||Dan Nelson6 Mar