CREATE TABLE cve_cve_tmp SELECT * from cve_cve
UPDATE cve_cve a INNER JOIN cve_cve_tmp b on a.id=b.id set a.is_important=b.is_important
补充:
常用的还有如下语句
INSERT INTO cve_cve(is_important) SELECT cve_cve_tmp WHERE cve_cve.id=cve_cve_tmp.id
CREATE TABLE cve_cve_tmp SELECT * from cve_cve
UPDATE cve_cve a INNER JOIN cve_cve_tmp b on a.id=b.id set a.is_important=b.is_important
常用的还有如下语句
INSERT INTO cve_cve(is_important) SELECT cve_cve_tmp WHERE cve_cve.id=cve_cve_tmp.id