* Phillip S. Baker
> How do I write a SQL call to take the results of a select statement and
> plug them into a new table in the DB?
If the new table exist, use INSERT ... SELECT:
http://www.mysql.com/doc/en/INSERT_SELECT.html >
If the new table does not exist, use CREATE TABLE ... SELECT
http:
How do I write a SQL call to take the results of a select statement and
plug them into a new table in the DB?
Thanks
Phillip
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.