CREATE TABLE t (
Id INT
);
INSERT INTO t (
with recursive gen as (
SELECT 1 AS num
UNION ALL
SELECT num+1 FROM gen WHERE num+1<=50
)
SELECT * FROM gen);
CREATE TABLE t_backup LIKE t;
SHOW CREATE TABLE t_backup;
CREATE TABLE t_backup2 ENGINE=MyIsam AS SELECT * FROM t;
SHOW CREATE TABLE t_backup2;