Re: SELECT to new table

2003-03-11 Thread Roger Baklund
* 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:

SELECT to new table

2003-03-10 Thread 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? Thanks Phillip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.