//更新指定游戏服务器最后启动记录的结束时间
update t_game_start_log set stop_time = now() where id = (select max(id) from (select * from t_game_start_log) as b where b.server_id = 21);
总结:Mysql update语句赋值嵌套select,更新和查询同一张表,必须取别名
//更新指定游戏服务器最后启动记录的结束时间
update t_game_start_log set stop_time = now() where id = (select max(id) from (select * from t_game_start_log) as b where b.server_id = 21);
总结:Mysql update语句赋值嵌套select,更新和查询同一张表,必须取别名