MySQL prevents the delete command from deleting data

We will use the delete command to delete records in the database in SQL. If you accidentally delete the records, it will be difficult to restore them. Next I will summarize some methods for deleting data but not deleting the database.

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: directly 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.