I have a client who exports their stock system to a tab seperated file which I import into MySQL using LOAD DATA INFILE.
There are 80 fields in the exported file, of which I only want 10.
Is there a way to skip fields in the text file when loading it to a table? I currently have TINYINY(1) fileds for the unused ones to reduce the table size (50,000 parts and growing each day) but it would be good to have only the fields I require in the table.
There are 80 fields in the exported file, of which I only want 10.
Is there a way to skip fields in the text file when loading it to a table? I currently have TINYINY(1) fileds for the unused ones to reduce the table size (50,000 parts and growing each day) but it would be good to have only the fields I require in the table.