Re: [PHP-DB] duplicate a table

2001-04-03 Thread Johannes Janson
Hi, just install phpMyAdmin which has a feature to duplicate tables structure only or structure and data. ""McShen"" [EMAIL PROTECTED] schrieb im Newsbeitrag 9aak89$ruv$[EMAIL PROTECTED]">news:9aak89$ruv$[EMAIL PROTECTED]... how do i duplicate a table? i tried create table refer2 select *

RE: [PHP-DB] duplicate a table

2001-04-03 Thread Rubanowicz, Lisa
I installed mySQLFront and it can do the same thing too through a GUI. You save a *.sql file with or without data. All the Best Lisa -Original Message- From: Johannes Janson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 2:36 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB

[PHP-DB] duplicate a table

2001-04-02 Thread McShen
how do i duplicate a table? i tried create table refer2 select * from refer; create table refer2 as select * from refer; they didn't work. my mysql version is mysql 3.22.28, -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

RE: [PHP-DB] duplicate a table

2001-04-02 Thread dime
a different structure. Thanks a lot. Peace. -Original Message- From: McShen [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 2:47 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] duplicate a table how do i duplicate a table? i tried create table refer2 select * from refer; create table