Question

mysql根据不同的id，修改莫一字段不同的值 批量修改

就是下面的sql语句，谁能帮我改改 ！！update shopex_orders set cost_mony in('91.56,262.66,-199.44,128.36,147.9') where order_id in(20101030097022,20101030109316,20101030105619,20101030104710,20101030102239)

Answer 1

这种批量修改的功能用一句SQL是不能实现的。update shopex_orders set cost_mony='91.56' where order_id=20101030097022;update shopex_orders set cost_mony=262.66' where order_id=20101030109316;update shopex_orders set cost_mony='-199.44' where order_id=20101030105619;update shopex_orders set cost_mony='128.36' where order_id=20101030104710;update shopex_orders set cost_mony='147.9' where order_id=20101030102239;

Answer 2

这种通常先用一表变量 (例子如下）或临时表将发来的数组存入；然后将你的表 INNER JOIN 这个临时表即可更新你表中的值了。DECLARE @tmptbl TABLE ( [cost_mony] real NOT NULL, [order_id] int NOT NULL);