UPDATE cdb_members m, cdb_usergroups u SET m.groupid = u.groupid WHERE u.type='member' AND m.credits < u.creditslower AND m.credits >= u.creditshigher AND m.adminid <=0;
复制代码
需要增加一个判断
即
UPDATE cdb_members m, cdb_usergroups u SET m.groupid = u.groupid WHERE u.type='member' AND m.credits < u.creditslower AND m.credits >= u.creditshigher AND m.adminid <=0 and m.groupid<>'4' and m.groupid<>'5'
UPDATE cdb_members m, cdb_usergroups u SET m.groupid = u.groupid WHERE u.type='member' AND m.credits < u.creditslower AND m.credits >= u.creditshigher AND m.adminid <=0;