MySQL converting tables?

[Yari]

Hi,

I have some pretty big tables that need to be changed around...

It's regarding a statistics program I built, and now I have a second version ready, but I have added quite a few tables for different data. The earlier version only has 2 tables, and I need to convert the data from it into the new 4 tables.... I was going to use PHP, but I thought it may be alot faster to use pure MySQL?

If so, can MySQL read all records from one table, then insert certain records into a second table?

I have almost a million records in one of my tables!

Any help would be much appreciated!

bye

Yari

[TheWiz]

you can insert records directly into an existing table by replacing the VALUES clause with a SELECT clause:

INSERT INTO tableName
(field list)
SELECT (field list)
FROM tableName2

be carefull the the type and order of fields are the same in both field lists, the names can be different.

[Yari]

Thank you very much, I will give it a go and let you know how i went!

Cheers,

Yari