Question

mysql update 批量更新多个条件同一个字段

表名：test
需要更新的字段：aaa
条件字段：uid
正常根据uid更新aaa就很简单嘛
update test set aaa=123456 where uid=1

但是现在有几十个uid，而且还是不连续性的怎么搞？
aaa字段都更新为123456

uid列表:
3,4,18,27,70,93,94,95,98,31,41,516,8656,8655,8658,8659,131,8674,8686,8691,8710,8722,8723,8735,8844,8845,8846,8847,8848,8849,8850,8851,8852,8853,8854,8855,8856,8857,8858,8859,8860,8861,8862,8863,8864,8865,8866,8867,8868,8869,8870,8871,8872,8873,8874,8875,8876,8877,8878,8879,8880,8881,8882,8883,8884,8885,8886,8887,8888,8889,8890,8891,8892,8893,8894,8895,8896,8897,8898,8899,8900,8901,8902,8903,8904,8905,8906,8907,8908,8909,8910,8911,8912,8913,8914,8915,8916,8917,8918,8919,8920,8921,8922,8923,8924,8925,8926,8927,8928,8929,8930,8931,8932,8933,8934,8935,8936,8937,8938,8939,8940,10918
就是把以上uid的aaa字段全部改成123456
谢谢了！

Answer 1

我想你的那个uid 一定是动态查询出来的吧 你可以动态生成sql 如：
update test set aaa=123456 where uid in ();
在括号里你就可以拼接之前查询出来的uid列表咯。

Answer 2

如果不是动态的uid，那就直接写一条SQL，也是用in()，
还有如果想保存已修改的uid，可以建个临时表，一个字段，把uid写入进去，然后关联查询并更新主表