摘要: UPDATE product p INNER JOIN productPrice pp ON p.productId = pp.productId SET pp.price = pp.price * 0.8, p.dateUpdate = CURDATE() WHERE p.dateCreated 阅读全文
posted @ 2016-09-12 00:53 思考的云 阅读(199) 评论(0) 推荐(0) 编辑