Deleting Duplicate Rows in a MySQL

Asked Dec 19 '17 at 17:33

Active Dec 19 '17 at 17:39

Viewed 24 times

My Code: DELETE FROM doctorreport WHERE id IN ( SELECT id FROM doctorreport GROUP BY id HAVING COUNT(*) > 1) LIMIT 1

Error: #1093 - You can't specify target table 'doctorreport' for update in FROM clause

asked Dec 19 '17 at 17:33

swapan

how do i solve error – swapan Dec 19 '17 at 17:37
By following the threads linked in your question – M Khalid Junaid Dec 19 '17 at 17:39

0 Answers0