you can create temporary table 'tmpTable' with columns A, B, C, D,
load data into 'tmpTable ' and then use INSERT INTO requiredTable (B,C,D) SELECT tmpTable.B, tmpTable.C, tmpTable.D FROM tmpTable
HTH, Dusan
----- Original Message ----- From: "Dan Stark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 01, 2004 9:52 PM
Subject: Disincluding columns when using load data
I've checked through the archives a documentation but cannot find an answer to my problem. I'm attempting to load data from a text file that has a column that is not present in my database table.
Table B C D
File A B C D
I've been trying to find a way to ignore the first column of the text file by specifiing columns like: (Null,B,C,D) or ('',B,C,D) but mysql doesn't understand these commands. Is there a way to ignore columns with load data?
TIA
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
