创建表的同时将查询的结果写入到数据表中
CREATE TABLE IF NOT EXISTS tbl_name [(create_definition,...)] select_statement
例：
CREATE TABLE IF NOT EXISTS job(id SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,name VARCHAR(20) NOT NULL) SELECT job FROM person GROUP BY job;
原文：http://www.cnblogs.com/beast-king/p/4674279.html