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
  • No, it will not work. I have already tried both commands. – ursitesion Aug 12 '14 at 8:19
  • Tested on my machine,maybe you`re not using mysql. – Mihai Aug 12 '14 at 8:23
  • I am using MysQL-5.1.53 community edition. – ursitesion Aug 12 '14 at 8:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.