关于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);

 

字段操作:

https://www.cnblogs.com/wenlj/p/5258102.html

posted @ 2018-02-24 17:19  zonehoo  阅读(471)  评论(0编辑  收藏  举报