通常,更新一列后,需要获取更新的值,做法是这样的:
update some_table set fields=fields+1 where some_condition=some_value;
然后
select fileds from some_tables where some_condition=some_value;
如果希望合并这两条查询,该如何做呢?
UPDATE some_table SET
fields = @amount := fields+1
WHERE some_condition=some_value LIMIT 1;
SELECT @amount;
当然,这里建议写成存储过程