sql---表复制

# 表复制
# 建表
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;

官网