On 20 Nov 2002, at 12:54, Steve Buehler wrote:
> What I am trying to do is to copy a mysql table to a new
> table name in a PHP script.
Use the query "SHOW CREATE TABLE $from_table" to get the SQL
statement for creating the table, then do
$create_table_sql = preg_replace(
'/^CREATE TABLE `[^`]+`/',
"CREATE TABLE $to_table",
$create_table_sql
);
to modify the SQL to create the new table. Execute the query to
create the empty table. To fill it, simply do
INSERT INTO $to_table SELECT * FROM $from_table
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
Phone 202-667-6653
---------------------------------------------------------------------
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
