mysql复制表结构

1.mysql 复制表结构

CREATE TABLE book_tmp AS SELECT * FROM book WHERE 1 = 2;