开发者

How do I update a column in 3rd row the same as a column in 2nd row in MySQL?

I'm doing it this way:

UPDATE products 
   SET products_image = (SELECT products_image 
                           FROM products 
             开发者_运维问答             WHERE products_id = 2) 
 WHERE products_id = 3;

...but get an error:

ERROR 1093 (HY000): You can't specify target table 'products' for update in FROM clause


UPDATE products p1, products p2 
SET p1.products_image=p2.products_image 
WHERE p1.id=3 AND p2.id=2;
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜