1、insert into cms_profile(typeid,ctgid,title,imgsrc)
select 3 as typeid, 21 as ctgid,title,imgsrc,imgpck from cms_profile where ctgid=12
//释义:
select 3 as typeid 21 :把原表的typid为21的,复制后typeid动态成3
select 3 as typeid, 21 as ctgid,title,imgsrc,imgpck from cms_profile where ctgid=12
//释义:
select 3 as typeid 21 :把原表的typid为21的,复制后typeid动态成3