I have a table I want to import some records into. The table has 4 columns
-
user_id, name, account, password.
The file I have to be imported has 3 columns -
password,name,account.
I have been trying to use load data infile and keep ending up with a lot of
junk in the database.
The file is of this format -
password,name,account
password,name,account
etc
File name is users and table name is users.
mysql> load data infile '/usr/home/chip/users' into table users
-> (name,password,account)
-> fields terminated by ',';
ERROR 1064: You have an error in your SQL syntax near 'fields terminated by ','' at l
ine 3
mysql>
Regards,
Chip Wiegand
Computer Services
www.simradusa.com
[EMAIL PROTECTED]
Simrad, Inc
Lynnwood, WA
425-712-1138
"There is no reason anyone would want a computer in their home."
--Ken Olson, president, chairman and founder of Digital Equipment Corp.,
1977
(-- Then why do I have nine? Somebody help me!)
---------------------------------------------------------------------
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
