Jump to content

Archived

This topic is now archived and is closed to further replies.

gladiator83x

Making a Duplicate Table in MySQL with php

Recommended Posts

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?

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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";

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.