user同步

insert into wcmuser(userid,username,truename,status,password)

select id as userid,user_name,user_name_zh as truename ,status ,'25D55AD283AA400'
from
(
  select id,user_name,user_name_zh, 30 as status
  from cmccitil.t_user
  where id>10000
  and id not in
      (
      select b.id
      from trsdba.wcmuser a,
      cmccitil.t_user b
      where a.username = b.user_name
      )
)

select * from wcmuser