Skip to content

-

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)