Jump to content


Photo

Making a Duplicate Table in MySQL with php


  • Please log in to reply
3 replies to this topic

#1 gladiator83x

gladiator83x
  • Members
  • PipPipPip
  • Advanced Member
  • 45 posts

Posted 22 July 2006 - 09:11 PM

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:

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


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



#2 mainewoods

mainewoods
  • Members
  • PipPipPip
  • Advanced Member
  • 685 posts
  • LocationMaine

Posted 22 July 2006 - 10:30 PM

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

CREATE TABLE new_tbl SELECT * FROM orig_tbl;

MySQL creates new columns for all elements in the SELECT.



#3 gladiator83x

gladiator83x
  • Members
  • PipPipPip
  • Advanced Member
  • 45 posts

Posted 22 July 2006 - 11:06 PM

Thanks Mainewoods

#4 gladiator83x

gladiator83x
  • Members
  • PipPipPip
  • Advanced Member
  • 45 posts

Posted 23 July 2006 - 07:29 AM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users