Copying a table with its structure, indexes, and associated triggers?

Asked 5 years, 4 months ago

Viewed 791 times

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.

Community♦

asked Aug 12 '14 at 7:54

ursitesion

1,4635 gold badges24 silver badges41 bronze badges

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

add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

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