Hi, I have a 72 fields data txt file and I was inserting all data previously but now I need only some of them to dump into the table.
I would like to select only 4 fields which are the 1st, 5th,28th and 71st fields. Is there a statement to do that. I have read http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html but could not find it... Thanks...
