Two methods for MySQL to prevent the delete command from deleting data _ MySQL

Two methods for MySQL to prevent the delete command from deleting data: bitsCN.com

Method 1
My common practice is to add a delete ID field in the database,
For example, if isdel = 1, the code deletes the field.

Method 2
Restrict mysql deletion

Add the parameter-U when starting MySQL.

-U, -- safe-updates Only allow UPDATE and DELETE that uses keys.

Its function is to prevent the execution of the delete statement without a conditional statement. If no where clause is added, the statement is not executed.

BitsCN.com