1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
mysql> SET @X = 20.7;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT ELT( (CEIL(@X)=@X) + 1 , @X ,TRUNCATE(@X,0));
+----------------------------------------------+
| ELT( (CEIL(@X)=@X) + 1 , @X ,TRUNCATE(@X,0)) |
+----------------------------------------------+
| 20.7 |
+----------------------------------------------+
1 row in set (0.00 sec)
mysql> SET @X = 20;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT ELT( (CEIL(@X)=@X) + 1 , @X ,TRUNCATE(@X,0));
+----------------------------------------------+
| ELT( (CEIL(@X)=@X) + 1 , @X ,TRUNCATE(@X,0)) |
+----------------------------------------------+
| 20 |
+----------------------------------------------+
1 row in set (0.00 sec) |
Partager