'！='和'<>'之间有什么区别在MySQL中 [英] whats the difference between '!=' and '<>' in mysql

问题描述

在mysql中!=和<>之间的区别是什么? 在SQL查询中，对于不相等的条件，哪个符号对用户是好的.有人可以告诉我在mysql中使用不相等的符号的优缺点.

whats the difference between != and <> in mysql. which symbol is good to user in sql query for not equal condition.can someone tell me whats the pros and cons of using the not equal symbol in mysql.

推荐答案

!=需要3次击键(Shift，！，=)，而<>需要3次击键(Shift，<，>).但是，触摸打字员必须换手才能击中该=.

!= requires 3 keystrokes (Shift, !, =), and <> requires 3 keystrokes (Shift, <, >). However a touch typist has to switch hands to hit that =.

您绝对应该在!=上使用<>.每次使用至少可以节省10毫秒的键入时间.

You should definitely use <> over !=. You'll save at least 10 milliseconds of typing for each use.

这篇关于'！='和'&lt;&gt;'之间有什么区别在MySQL中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！