mysql> create table test (status integer(16));
Query OK, 0 rows affected (0.06 sec)

mysql> insert into test values(1);
Query OK, 1 row affected (0.00 sec)

mysql> insert into test values(0);
Query OK, 1 row affected (0.00 sec)

mysql> update test set status = not status;
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> select * from test;
+--------+
| status |
+--------+
|      0 |
|      1 |
+--------+
2 rows in set (0.00 sec)

mysql> update test set status = not status;
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> select * from test;
+--------+
| status |
+--------+
|      1 |
|      0 |
+--------+
2 rows in set (0.00 sec)