April 1st, 2014, 07:29 AM
Skip columns load
Is the infobright LOAD statment support selectif loads. I have a table of objects, and an input file with some columns that i need to keep them dummy in my table, so i tryed with the mysql syntax :
LOAD DATA INFILE 'objects9925.txt'
INTO TABLE obj(id, @dummy, name, @dummy, datecre,@dummy,@dummy,userid);
The script on top loads also the columns that i want to keep without values.
April 1st, 2014, 09:18 AM
Please post the DDL scripts and email me the data, I will send you the script back on how to load.
Tags for this Thread