Parentheses in the column heading
From: Stefan Ram <ram_at_zedat.fu-berlin.de>
Date: 12 Sep 2015 19:34:05 GMT
Message-ID: <parentheses-20150912202853_at_ram.dialup.fu-berlin.de>
mysql> SELECT ( -65 ) FROM ONE;
+---------+
1 row in set (0.00 sec)
1 row in set (0.00 sec)
Date: 12 Sep 2015 19:34:05 GMT
Message-ID: <parentheses-20150912202853_at_ram.dialup.fu-berlin.de>
mysql> SELECT ( -65 ) FROM ONE;
+---------+ | ( -65 ) | +---------+ | -65 |
+---------+
1 row in set (0.00 sec)
mysql> SELECT ( 65 ) FROM ONE;
+----+
| 65 |
+----+
| 65 |
+----+
1 row in set (0.00 sec)
When the expression inside the parentheses contains a minus sign, the parentheses are shown in the column header of the result table. When the minus is removed, the parentheses too disappear from the column header. Received on Sat Sep 12 2015 - 21:34:05 CEST