关于mysql一边查一边更新
update test_table set user_id = 112 where id in
(select id from ( select id from test_table where number in ( 008667 , 008706 , 008707 ) ) as s);
字段操作:
update test_table set user_id = 112 where id in
(select id from ( select id from test_table where number in ( 008667 , 008706 , 008707 ) ) as s);
字段操作: