Re: Parentheses in the column heading

On 12-09-15 21:34, Stefan Ram wrote:
> 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.
>

When double quotest are added, the parentheses remain: mysql]> select 65 as "( 65 )";
+--------+
| ( 65 ) |
+--------+
| 65 |
+--------+
1 row in set (0.00 sec) Received on Sat Sep 12 2015 - 21:51:15 CEST