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);
字段操作:
转载于:https://www.cnblogs.com/zonehoo/p/8467007.html