update T_Log_Table as A set A.iState = 0, logout = '异常退出' where A.id = (select max(T.id) from
(select * from T_Log_Table) as T where T.Acount = 'admin' and T.logIP = '192.168.1.115' and T.dateout is null)
查询同时更新
最新推荐文章于 2024-06-20 09:23:39 发布