我写了如下语句: insert into t_wh_user_dwbm(uname,dwbm) select uname,'01' from t_wh_userinfo where uname like '%zjy%' 为啥报违反唯一约束,uname和dwbm都不是主见
insert t_wh_user_dwbm(xh,uname,dwbm) select xh='01',uname=(select uname from t_wh_userinfo where uname not in(select uname from t_wh_user_dwbm),dwbm='01'
如果你允许所有的列为可重复的话, insert into t_wh_user_dwbm(xh,uname,dwbm) select '01',uname,'01' from t_wh_userinfo应该没有问题,还是先看看你的字段设置吧,
insert into t_wh_user_dwbm(uname,dwbm) select uname,'01' from t_wh_userinfo where uname like '%zjy%'
为啥报违反唯一约束,uname和dwbm都不是主见
select xh='01',uname=(select uname from t_wh_userinfo where uname not in(select uname from t_wh_user_dwbm),dwbm='01'
insert into t_wh_user_dwbm(xh,uname,dwbm) select '01',uname,'01' from t_wh_userinfo应该没有问题,还是先看看你的字段设置吧,