I have studied this post on Stack Overflow: Fastest way to copy a table in MySQL.
But no answer is copying everything like the table's structure, data, indexes as well as associated triggers.
- Is it possible in MySQL? If yes, how can we do this?
- Is it also possible to copy triggers from one table to another?
CREATE TABLE a LIKE b;INSERT INTO a SELECT * FROM b
– Mihai Aug 12 '14 at 8:14