insert into article (id,class,title,content) select id,'2',title,content from article where class='1'
如果id為自動(dòng)編號(hào),就把改為:
insert into article (class,title,content) select '2',title,content from article where class='1'
如果class為數(shù)字類型,則去掉單引號(hào).
