Dear Chip,
you cannot use reserved words as column names. You have "password" as a
col name which is a reserved word in SQL. The error derives from there,
only MySQL gets it wrong and points you into the wrong direction as to
where to search.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 10:48 PM
Subject: Import data question
> 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
>
>
---------------------------------------------------------------------
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
