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$[EMAIL PROTECTED]">news:9aak9c$t7t$[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 General 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 General 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]
