View Full Version : splitting table

06-26-2003, 08:44 PM
I have a table called song

Song contains name, size, and language

Only 'e' and 'c' are in the language ( e for english and c for chinese)

how do I make this one table (Song) into 2 different talbes (English_song and Chinese_song) according to it's language?

Thank you

06-26-2003, 09:23 PM
do you really need to split the table in two? I will make things harder for your code.

The easiest way would be to copy (using a db frontend or mysqlhotcopy) the table, and then run a deletestatement on each table

delete from englishtable where language='c'
delete from chinisetable where language='e'