<>是什么在SQL上的意思 [英] What does <> mean on SQL

问题描述

我一直在寻找<>对sql语法的含义，但是由于google删除了我的特殊字符，因此很难用google搜索.

I was looking for what the <> mean on sql syntax but it was hard to google for it since google removes my special characters.

具体来说，我试图弄清楚以下含义:

Specifically I was trying to figure out what the following means:

... AND (s1.skips > 0 OR s1.fails <> 1 OR s2.skips > 0);

是否有关于<>子句的清晰文档?

Is there any clear documentation talking about the <> clause?

推荐答案

<>在许多其他编程语言中都等同于!=.

<> is the equivalent of != in many other programming languages.

具体来说，如果其中任何一个为真，则MySQL查询会进行以下限制:

Specifically, your MySQL query makes the following restrictions if any of these are true:

• s1.skips > 0- s1 跳过的次数大于0
• s1.fails <> 1- s1 失败的数量不是1
• s2.skips > 0- s2 跳过的次数大于0

• s1.skips > 0 - Number of s1 skips is greater than 0
• s1.fails <> 1 - Number of s1 fails is NOT 1
• s2.skips > 0 - Number of s2 skips is greater than 0

这篇关于&lt;&gt;是什么在SQL上的意思的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！