巧用 MySQL 自定义变量一条语句实现 UPDATE + SELECT

示例

mysql> select * from t_job_queue order by id desc limit 1;
+------+--------+---------------+---------------------+------------+------------+
| id   | status | params        | result              | update_id1 | update_id2 |
+------+--------+---------------+---------------------+------------+------------+
| 1060 |      2 | key1=1&key2=2 | 2017-03-03 00:48:57 | 1488473337 |  713371054 |
+------+--------+---------------+---------------------+------------+------------+
1 row in set (0.00 sec)

mysql> update t_job_queue set status=(@old_status:=status), status=0 where id=1060;          
Query OK, 1 row affected (0.00 sec)
Rows matched: 1