fastest way to copy a table in mysql
- by Anon
which one is the fastest way to completely copy a table on mysql ?
CREATE TABLE copy LIKE original;
INSERT INTO copy SELECT * FROM original;
or
CREATE TABLE copy SELECT * FROM original;
ALTER TABLE copy ADD PRIMARY KEY (id);
or theres another way ?
PS. can't use command-line tools like mysqldump, must be on-the-fly.
