SET @ts = CONCAT('testnew', DATE_FORMAT(NOW(), '%Y%m%d') );
SET @test = CONCAT( 'CREATE TABLE ' , @ts , ' LIKE test ; INSERT INTO ',@ts,' SELECT * FROM test;');

PREPARE test FROM @ts;
EXECUTE test;
DEALLOCATE PREPARE test;

INSERT INTO testnew20190306 SELECT * FROM test;