I added a record in a table in MySQL database, now I am trying to delete that particular record from table, but it is not getting deleted & showing this message:
#1062 - Duplicate entry '3107' for key 'PRIMARY'
How do I delete this entry?
Asked
Active
Viewed 261 times
0
-
1which query you have try to DELETE it ? – Bernd Buffen Jul 06 '16 at 10:49
-
check this link http://stackoverflow.com/questions/3311903/remove-duplicate-rows-in-mysql – Karthik N Jul 06 '16 at 10:53
-
Remember that you must COMMIT your changes. – Bob Jarvis - Слава Україні Jul 06 '16 at 11:40
-
@BerndBuffen I tried to delete the record by both running sql query and selecting the delete option for that record but it is not getting deleted. Showing me the same message as mentioned above. – Madhu Jul 06 '16 at 12:08
2 Answers
1
You can not get this error during DELETE. UPDATE or INSERT can return that
So either you are not running DELETE or you have trigger on your table, that is making some other changes, that give you that error.
If child tables have ON DELETE CASCADE,check them for triggers as well.
Pavel Katiushyn
- 795
- 4
- 9
0
delete from table_name [where condition];
use this statement, replace table_name with your table name and put the condition.
If you do not specify where clause, every records will be deleted.
Aseem PM
- 97
- 6