Copy Query Result to another mysql table

Question

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.

Answer 1

INSERT
INTO    new_table_1
SELECT  *
FROM    existing_table
WHERE   condition_for_table_1;

INSERT
INTO    new_table_2
SELECT  *
FROM    existing_table
WHERE   condition_for_table_2;

Answer 2

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;