update sdb_goods set price='57.6', (update sdb_goods_lv_price set price='57.6' where goods_id=135 and level_id=4) where bn =1020205005
update sdb_goods set price='57.6', (update sdb_goods_lv_price set price='57.6' where goods_id=135 and level_id=4) where bn =1020205005
update sdb_goods Inner Join sdb_goods_lv_price ON sdb_goods_lv_price.goods_id = sdb_goods.goods_id
set sdb_goods.price = '57.6' , sdb_goods_lv_price.price='50.56'where sdb_goods_lv_price.level_id = 3 and sdb_goods_lv_price.goods_id = 135
mysql是可以这样写的,好像其它数据库是不行的