比如我要将表“user”表的数据拷贝到“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