MySQL：返回更新的行

您不能直接合并这些查询。但是您可以编写一个存储过程来执行两个查询。例：

delimiter |create procedure upd_select(IN group INT, IN time INT)begin    UPDATE table SET time = 0 WHERe group_id = @group and time > @time;    SELECT * FROM table WHERe group_id = @group and time > @time;end;|delimiter ;