Making a Duplicate Table in MySQL with php

[gladiator83x]

Hi all,

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:

[color=red]<?php
// 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!";
?>
[/color]

I just don't know how to copy a table; any suggestions?

[mainewoods]

You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement:

[code]CREATE TABLE new_tbl SELECT * FROM orig_tbl;[/code]

MySQL creates new columns for all elements in the SELECT.

[gladiator83x]

Thanks Mainewoods

[gladiator83x]

Hi All,

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";