mysql数据库中一个订单数据表中订单号字段和金额字段,需要批量修改10个订单号的金额,应该如何执行sql语句实现批量替换
UPDATE gc_dmh_school_order
SET s_money = 0
WHERE ordersn IN ('ORD101010', 'ORD101010', 'ORD101010', 'ORD101010', 'ORD101010', 'ORD101010', 'ORD101010', 'ORD101010', 'ORD101010', 'ORD101010', 'ORD101010', 'ORD101010', 'ORD101010', 'ORD101010', 'ORD101010');