您不能直接合并这些查询。但是您可以编写一个存储过程来执行两个查询。例:
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 ;