MYSQL 和我开了个玩笑!
UPDATE `root2`.`ecs_goods_attr` SET attr_price = attr_price - '1' WHERE goods_id = '14866' AND attr_value='520 '
改为:UPDATE `root2`.`ecs_goods_attr` SET attr_price = attr_price - '1' WHERE goods_id = '14866' AND attr_value='520 '
搞了一个下午,就是一个空格把我搞的头晕目眩。汗,有时候真累。慢慢来吧。。