* 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: <URL: http://www.mysql.com/doc/en/INSERT_SELECT.html > If the new table does not exist, use CREATE TABLE ... SELECT <URL: http://www.mysql.com/doc/en/CREATE_TABLE.html > (Far down on the page you can find a description on how to append a SELECT statement to the end of a CREATE TABLE statement.) HTH, -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php