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] duplicate a table


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 * 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 commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to