If I use a simple table such as :
create table test ( a int );
insert into test values ( 1 ) , ( 2 ) , ( 2 ) , ( 3 );
select * from test where a <> 2;
select * from test where a != 2;
Both give me :
+------+
| a |
+------+
| 1 |
| 3 |
+------+
2 rows in set (0.00 sec)
So what is the difference between <> and != mysql operators ?
<> should be preferred, all things being equal, since it accords with the sql standard and is technically more portable...
!= is non-standard, but most db's implement it.
sql:2008 grammar:
<not equals operator> ::=
<>
<> and easily to transplant the query in different RDBMS. so it's considering portable?They are both exactly the same. See the documentation.
http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_not-equal
<> even though != feels more natural to me. <> just seems right for any SQL representation.No difference. <> is sql standard, != non-standard.
Nothing. Simply two different ways of writing the same thing
