Oct 31, 2017

Clone a table in MySQL

CREATE TABLE t_clone LIKE t;
INSERT t_copy SELECT * FROM t;

Or simply:
CREATE TABLE t_clone SELECT * FROM t;