Re: [PHP] duplicate a table

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

"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