Re: [PHP] duplicate a table

2001-04-02 Thread Chris Lee
im to lazy to figure out the mysql commands, just copy the files. cp sometable.MYI sometable2.MYI cp sometable.MYD sometable.MYD cp sometable.frm sometable.frm mysqladmin flush-tables easier. -- Chris Lee [EMAIL PROTECTED] ""McShen"" <[EMAIL PROTECTED]> wrote in message 9aak9c$t7t$[EMA

Re: [PHP] duplicate a table

2001-04-02 Thread Steve Werby
"McShen" <[EMAIL PROTECTED]> wrote: > 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, This has nothing to do with PHP - you should post to the MySQL list inst

[PHP] 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 General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,