放到同一张表中 project_user表不是有project =1和2的记录了吗 干吗还插入 insert into project_user select * from project_user where project=1 or 2
INSERT INTO tta SELECT c.`project`,c.`user` FROM tta b RIGHT JOIN ( SELECT * FROM (SELECT DISTINCT a.`project` FROM tta a) a1, (SELECT DISTINCT a.`user` FROM tta a) b1) c ON b.`user`=c.`user` AND b.`project`=c.`project` WHERE b.`project` IS NULL;
以下是我自己想出来的办法: insert into `project_user` (project,user,) SELECT distinct project,3 FROM `project_user` where project not in( SELECT project FROM `project_user` where user = '3')
insert into project_user select * from project_user where project=1 or 2
SELECT c.`project`,c.`user` FROM tta b RIGHT JOIN (
SELECT * FROM
(SELECT DISTINCT a.`project` FROM tta a) a1,
(SELECT DISTINCT a.`user` FROM tta a) b1) c
ON b.`user`=c.`user` AND b.`project`=c.`project` WHERE b.`project` IS NULL;
insert into `project_user` (project,user,)
SELECT distinct project,3 FROM `project_user` where project not in(
SELECT project FROM `project_user` where user = '3')