MySQL-1093 - You can't specify target table 'product' for update in FROM clause
原来的SQL语句UPDATE product pSET p.price_strategy = 'FREE'WHERE p.id IN ( SELECT p1.id FROM product p1 LEFT JOIN price_info price ON p1.id = price.product_id WHERE p1.tag =
原创
2018-01-10 15:32:15 ·
1246 阅读 ·
0 评论