Re: Import data question

2001-08-07 Thread Stefan Hinz
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 iC

Re: Import data question

2001-08-06 Thread Grigory Bakunov
Date |Mon, 6 Aug 2001 13:48:41 -0700 >From |[EMAIL PROTECTED] Hello! C> I have a table I want to import some records into. The table has 4 columns C> - C> user_id, name, account, password. C> The file I have to be imported has 3 columns - C> password,name,account. C> I have been trying to use lo