INSERT INTO classm_t_class_people_link (userid,classid) values( 63201654876799020,0) where not exists (select ctcpl.id from classm_t_class_people_link ctcpl where ctcpl.userid=63201654876799020 and classid=0)上面的SQL哪儿错啦啊?
调试欢乐多
INSERT INTO `tb` (`Id`,`Name`)
SELECT 1,'ccc'
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `tb` WHERE `Id`=1 LIMIT 1);
但是只写这个就没有错误啊 INSERT INTO classm_t_class_people_link (userid,classid) VALUES(63201654876799020,0)