这题非常简单,但还是记录一下自己愚蠢的错误
测试用例
题目要求
1
# Write your MySQL query statement below
SELECT name
FROM Customer
WHERE NOT referee_id LIKE “2”
错误点: 用LIKE(多用于字符)去判断数字,舍近求远
2
# Write your MySQL query statement below
SELECT name
FROM Customer
WHERE NOT referee_id=2
错误点:用了NOT和=,但是忽略NULL判断,附一个leetcode官解
3
# Write your MySQL query statement below
SELECT name
FROM Customer
WHERE referee_id<>2 OR referee_id IS NULL
终于对了!! 注意OR的使用,<>或!=的使用