比如我要將表“user”表的數(shù)據(jù)拷貝到“user_version”表里：

• user_version表字段包含了user表字段

INSERT INTO user_version
  SELECT * FROM user

• 表user_version與表user部分字段相同

INSERT INTO user_version 
  (user_id, user_name, sex, tel, status, email, version_id)
SELECT (user_id, user_name, sex, tel, status, email, 1 version_id) FROM user