# 表复制
# 建表
CREATE TABLE table1
(
field_1 INT NOT NULL AUTO_INCREMENT,
field_2 VARCHAR(20),
field_3 VARCHAR(20),
PRIMARY KEY (field_1)
);
CREATE TABLE table2
(
field_1 INT NOT NULL AUTO_INCREMENT,
field_2 VARCHAR(20),
field_3 VARCHAR(20),
field_4 VARCHAR(20),
PRIMARY KEY (field_1)
);
# 添加数据
INSERT INTO table1
(field_2, field_3)
VALUES
('key1', 'value1'),
('key2', 'value2'),
('key3', 'value3');
# 使用INSERT INTO SELECT语句进行表复制:将table1中的数据复制到table2中,table2需要存在,否则会提示[42S02][1146] Table 'test.table2' doesn't exist
INSERT INTO table2(field_2, field_3) SELECT t1.field_2, t1.field_3 FROM table1 t1;
# 使用SELECT INTO语句进行表复制:将table1中的数据复制到table2中,table2需要不存在
# SELECT t1.field_1, t1.field_2, t1.field_3 INTO table2 FROM table1 t1;
DROP TABLE table1;
DROP TABLE table2;
DROP TABLE table3;
官网