INSERT INTO
user_dept(user_id,dept_id)
select 3,2
FROM DUAL ··········mysql内置的一张表,可以直接用
WHERE not EXISTS (SELECT id FROM user_dept WHERE user_id=3 and dept_id=2);
INSERT INTO
user_dept(user_id,dept_id)
select 3,2
FROM DUAL ··········mysql内置的一张表,可以直接用
WHERE not EXISTS (SELECT id FROM user_dept WHERE user_id=3 and dept_id=2);