How to split 1 table into several tables?
I'm new with SQL, bat have some experiance with mysql/PHP.
I've succesfully imported a CSV file with SQLoader into a table(TEST) it contains firtsname, lastname, adres, zipcode, city.
Now I want to split the table test into two tables linked with id.
it must be something like this (I hope),
create table split1,slpit2
query :=select * from TEST;
INSERT INTO SPLIT1,SPLIT2 (split1.firstname,split1.lastname,split2.adres,split2.zipcode,split2.city) VALUES (value,value,value,value,value)
Please advise how to proceed,