I am trying to import a large CSV file into a MySQL database. I have loaded the entire file into one flat table. i can select the data that needs to go into separate tables using select statements, my question is how do i copy the results of those select queries to different tables. i would prefer to do it completely in SQL and not have to worry about using a scripting language.
INSERT INTO anothertable (list, of , column, names, to, give, values, for) SELECT list, of, column, names, of, compatible, column, types FROM bigimportedtable WHERE possibly you want a predicate or maybe not;