[MySQL] 같지 않다
https://leetcode.com/problems/find-customer-referee/
Find Customer Referee - LeetCode
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
<>
!=
서로 같은 뜻으로 같지 않다를 나타내며 성능 차이는 없다.
다만, 문제에서도 알 수 있듯이 NULL은 처리가 되지 않기 때문에 따로 처리해줘야 한다.
Reference
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#operator_not-equal
MySQL :: MySQL 8.0 Reference Manual :: 12.4.2 Comparison Functions and Operators
12.4.2 Comparison Functions and Operators Table 12.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to ope
dev.mysql.com