开发者

Using <> in MySQL

开发者 https://www.devze.com 2023-03-25 03:24 出处:网络
I have come across<> used in a statement conditions a few times. Example: SELECT param, d.param FROM panel p join object d on p.i开发者_如何学God=d.id

I have come across <> used in a statement conditions a few times. Example:

SELECT param, d.param
FROM panel p join object d on p.i开发者_如何学God=d.id 
WHERE param IS NOT NULL and param<>''

Let me confirm the statement above has not been tested, it mimics some of the statements that I have come across.

My question is, what is the meaning of the the diamond <> condition?


<> is like NOT .. = .. and !=. It means not equal.

MySQL comparison operators - not equal


its the opposite of "equal" so it is "not equal".

in C it is !=

so in your question it means param is not a empty string

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号