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

Posted by user198729 on Stack Overflow See other posts from Stack Overflow or by user198729
Published on 2010-05-22T04:03:56Z Indexed on 2010/05/22 4:10 UTC
Read the original article Hit count: 224

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

© Stack Overflow or respective owner