+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    May 2012

    Skip columns load

    Hi All,

    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.

  2. #2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts