I have a mysql master-slave replication setup. when I checked "show slave status", I got the result as "Slave_Sql_running:No" and Last error as "Duplicate entry 'x' on query." But when I tried to delete the entry from that table result shown as "0 rows affected". I tried to fetch the record using select statement.Even then the result shown as "0 rows affected". Then I checked slave status again. The same state persists. And the same error.
Please give me a solution.
Thanks and regards, Praveen