List:General Discussion« Previous MessageNext Message »
From:Dusan Pavlica Date:November 2 2004 9:55am
Subject:Re: Disincluding columns when using load data
View as plain text  
Hi Dan,
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" <spokeman@stripped>
To: <mysql@stripped>
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/mysql?unsub=1
Thread
Disincluding columns when using load dataDan Stark1 Nov
  • Re: Disincluding columns when using load dataGleb Paharenko2 Nov
  • Re: Disincluding columns when using load dataDusan Pavlica2 Nov