MySQL Bugs: #62961: update..........on duplicate Key delete

Bug #62961	update..........on duplicate Key delete
Submitted:	27 Oct 2011 8:02
Reporter:	j doe	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S4 (Feature request)
Version:	5	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	new sentence, update..........on duplicate Key delete

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Erasing data easily when the modification line give us a duplicate key

How to repeat:
no way to repeat just a new feature suggested

Suggested fix:
Hi,
I contact you to suggest a new syntax for mysql when we make an update.
That could be great to apply an
"update..........on duplicate Key delete.." as the "insert ...... on duplicate key update.." if the update create a duplicate.
Like this we could erase the line unuseful automaticaly if his modification create datas which allready inserted in other line in the database.
BEcause modifing a line means the old datas are unwanted anymore and if the new exist already in other line we can erase with no doubt

Thanks