比如我要將表“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
