To copy just structure and data MySQl

To copy just structure and data use this one:

CREATE TABLE tbl_new AS SELECT * FROM tbl_old;