Re: Duplicating a table? :)

[Claude Martin]

> Just want to know the right command for
> duplicating a table? :)

you would use a tool to do so. like phpmyadmin or a program that you run on your client.
else you'd have to create a new table and then copy all rows:

CREATE TABLE `database`.`copy` ( ??? ) TYPE = ???;

INSERT INTO `database`.`copy` SELECT * FROM `database`.`mytable` ;

http://animalliberation.tk http://veganismus.ch
http://maqi.de http://tierrechtskochbuch.de