I have a csv file with 3 columns I want to import into MySQL with Load data infile. The columns are date, item, and qty. I need all three for one table they are going in but only item and qty for the second table. How can I perform this? Would it be the same as Ignore Row?
If you are using the Import / Export wizard, when you get to Select Source Tables and Views click on the button "Edit Mappings" on the bottom left of the screen. That opens column mappings screen; on the destination column select Ignore to remove the column you don't want to import.