Copy a MySQL Table

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

[448191]

The problem is not in your query.

From the MySQL manual:
[quote]CREATE TABLE new_tbl SELECT * FROM orig_tbl;[/quote]

Look elsewhere.