DELETE FROM students WHERE id=3 AND id=4; 这样为啥运行不成功呢

Discuss / SQL / DELETE FROM students WHERE id=3 AND id=4; 这样为啥运行不成功呢

Back

Topic source

#1 Created at ... [Delete] [Delete and Lock User]

DELETE FROM students WHERE id=3 AND id=4; 这个不应该是删除 id=3和id=4的记录吗

#2 Created at ... [Delete] [Delete and Lock User]

哦，明白了是在id=3的基础上满足id=4的

#3 Created at ... [Delete] [Delete and Lock User]

那应该怎么修改呢

#4 Created at ... [Delete] [Delete and Lock User]

这个and表示的不是和，是且。如果想删除id=3和id=4，应该用id=3 or id=4。

#5 Created at ... [Delete] [Delete and Lock User]

好家伙你id怎么同时满足等于3又等于4的