XxERpezy

1CREATE TEMPORARY TABLE if not exists testTable (ID INT NOT NULL, PRIMARY KEY(ID)) engine=memory AS  select 100 ); 
2
3CREATE TEMPORARY TABLE if not exists testTable_dup LIKE testTable ;
4
5INSERT into testTable_dup Select * from testTable