insert into p_web p (p.tid,p.title,p.fileurl,p.columnid,p.columnname)(select l.tid,l.linkname,l.linkurl,'3033' as columnid from p_link l where l.columnid=337)
insert into expertinfo
(expertid,expertname,expertcode,sex,enabled)
select
primarykey as expertid,
name as expertname,
'' as expertcode,
case sex when '男' then '1' when '0' then '女' end as sex,
'0' as ENABLED
from experttmp
CASE改用DECODE 也可以