1、复制表结构
a、创建和table2结构一样的table1表
CREATE TABLE table1 LIKE table2;
b、复制部分字段
CREATE TABLE table1 AS (SELECT ID,SNAME,SCORE FROM table2);
2、复制结构和数据
CREATE TABLE table1 LIKE table2;
INSERT INTO table1 SELECT * FROM table2;
3、复制表中的部分内容的同时定义表中的字段信息
CREATE TABLE table1 (ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY) AS (SELECT ID,SNAME,SCORE FROM table2);
4、复制表中一些字段并且同时重命名列名
CREATE TABLE table1 AS (SELECT ID AS SID,SNAME AS STU_NAME,SCORE AS STU_SCORE FROM table2);