MySQL Tutorial/Comparison Functions Operators/Equal
Версия от 13:44, 26 мая 2010; (обсуждение)
Equal: =
mysql>
mysql> SELECT 1 = 0;
+-------+
| 1 = 0 |
+-------+
| 0 |
+-------+
1 row in set (0.00 sec)
mysql>
mysql>
SELECT "0.
mysql>
mysql>
mysql>
mysql> SELECT "0.0" = 0;
+-----------+
| "0.0" = 0 |
+-----------+
| 1 |
+-----------+
1 row in set (0.00 sec)
SELECT "0.
mysql>
mysql> SELECT "0.01" = 0;
+------------+
| "0.01" = 0 |
+------------+
| 0 |
+------------+
1 row in set (0.00 sec)
Type conversion when using the Equal operator
mysql>
mysql> SELECT "1" = 1;
+---------+
| "1" = 1 |
+---------+
| 1 |
+---------+
1 row in set (0.00 sec)