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

Question

I'm doing it this way,but get an error:

mysql> update products set products_image=(select products_image from products where products_id=2) where products_id=3;
ERROR 1093 (HY000): You can't specify target table 'products' for update in FROM clause

Answer 1

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