Copy query result to another mysql table

Question

I am trying to import a large CSV file into a MySQL database. I uploaded the entire file to one flat table. I can select the data that needs to be moved to separate tables using select statements, my question is how to copy the results of these select queries to different tables. I would rather do it completely in SQL and not worry about using a scripting language.

Answer 1

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;

Answer 2

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 3

, . , new_table_1 , "INSERT INTO" "CREATE TABLE".