Making a Duplicate Table in MySQL with php
Posted 22 July 2006 - 09:11 PM
I was looking online to see if there was a way that I could somehow copy one of the tables in my database, but I was unsuccessful. I know how to alter a table and re-name a table. I usually create my tables like so:
// Create a MySQL table in the selected database
mysql_query("CREATE TABLE End_Review( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id),topic_title VARCHAR(50),date DATETIME)") or die(mysql_error());
echo "Table Created!";
I just don't know how to copy a table; any suggestions?
Posted 22 July 2006 - 10:30 PM
CREATE TABLE new_tbl SELECT * FROM orig_tbl;
MySQL creates new columns for all elements in the SELECT.
Posted 23 July 2006 - 07:29 AM
I tried to copy a table by using this line below but the duplicate table did not create--any suggestions?
$query ="CREATE TABLE commentstate2 SELECT * FROM commentstate";
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users