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 *
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
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
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