MYSSQL--Subquery returns more than 1 row
学习MYSQL语句时 子查询出现Subquery returns more than 1 rowSELECT * FROM grade WHERE id =(SELECT id FROM student WHERE sex='男')会出现异常解决办法:=后面加any SELECT * FROM grade WHERE id =ANY(SELECT id FROM student WHERE sex='男')或者使用INSELECT * FROM grade WHERE id IN(SELEC
原创
2022-04-08 14:45:17 ·
294 阅读 ·
0 评论