DROP TABLE IF EXISTS t1,t2;

CREATE TABLE t1 (a INT COMMENT 'test1');

CREATE TABLE t2 (a INT COMMENT 'test2') AS SELECT * FROM t1;

SHOW CREATE TABLE t1;

SHOW CREATE TABLE t2;

+-------+-------------------------------------------------------------------------------------------------------+

| Table | Create Table                                                                                          |

+-------+-------------------------------------------------------------------------------------------------------+

| t2    | CREATE TABLE `t2` (

  `a` int(11) DEFAULT NULL COMMENT 'test1'

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

+-------+-------------------------------------------------------------------------------------------------------+