How do I update a column in 3rd row the same as a column in 2nd row in MySQL?
- by user198729
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