-
Description
Unary minus. This operator changes the sign of the operand.
Syntax
> SELECT -column1, -column2, ...
FROM table_name;
Examples
mysql> select -2;
+------+
| -2 |
+------+
| -2 |
+------+
create table t2(c1 int, c2 int);
insert into t2 values (-3, 2);
insert into t2 values (1, 2);
mysql> select -c1 from t2;
+------+
| -c1 |
+------+
| 3 |
| -1 |
+------+
2 rows in set (0.00 sec)