Bug #2644 Secure record deletion
Submitted: 4 Feb 2004 14:17 Modified: 11 Mar 2019 9:35
Reporter: Julian Kurz Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version:8.0 OS:Any (all)
Assigned to: Assigned Account CPU Architecture:Any

[4 Feb 2004 14:17] Julian Kurz 
Description:
It would be cool to have an option to the DELETE statement, that securely deletes the records from memory and hard disk, just like these various "wiping"-tools do for files. This can be done by overwriting it with ones, zeros and random data several times.

How to repeat:
?!

Suggested fix:
Some option like:

DELETE SECURELY FROM mytable WHERE id = 7
[20 Nov 2007 18:10] Sven Müchert 
I'd be happy about this, too.

A related thing would be to have a secure update of an existing record, ensuring that overwritten data is really gone:

UPDATE SECURELY customers SET password="encryptedpasswordstring" WHERE id=1234;