0

The following query only copies column names, data types, indices and constraints. But I also want to copy the triggers, how can I do this?

CREATE TABLE tbl_order_temp LIKE tbl_order;
DarkBee
  • 16,592
  • 6
  • 46
  • 58
Apey waghdeve
  • 11
  • 1
  • See: [MySQL - Duplicate a Table WITH Triggers](https://stackoverflow.com/questions/49264051/mysql-duplicate-a-table-with-triggers) and [How to copy a trigger from one table to another](https://stackoverflow.com/questions/56463020/how-to-copy-a-trigger-from-one-table-to-another) and [MySQL "CREATE TABLE LIKE" include triggers](https://dba.stackexchange.com/questions/145042/mysql-create-table-like-include-triggers) – showdev May 12 '23 at 06:56

0 Answers0