RE: [PHP-DB] duplicate a table
| From: | Rubanowicz, Lisa | Date: | Tue, 03 Apr 2001 13:28:03 +0000 |
| Subject: | RE: [PHP-DB] duplicate a table | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8182@lists.php.net to get a copy of this message | ||
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:johannes.janson@gmx.de]
Sent: Tuesday, April 03, 2001 2:36 PM
To: php-db@lists.php.net
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"" <webmaster@celebritieszones.com> schrieb im Newsbeitrag
news:9aak89$ruv$1@toye.p.sourceforge.net...
>
> 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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net