Creating a table from a query in MySQL/PHP

If there is any auto increment column in your existing tables that will be not remain auto_increment in the table to be created.

You could try by selecting columns instead of * there should be an error of column Ambiguous.

<?php
// Make a MySQL Connection
mysql_connect("localhost", "admin", "1admin") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

// Create a MySQL table in the selected database
mysql_query("CREATE TABLE example(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
 name VARCHAR(30), 
 age INT)")
 or die(mysql_error());  

echo "Table Created!";

?>

copy-pasted it from http://www.tizag.com/mysqlTutorial/mysqltables.php