DELETE

The DELETE statement deletes data from a specific table of a database. For example, the following command deletes a data from the user table that carries the ID 1:

DELETE FROM user WHERE id = 1;

Even though you can use this statement to delete unwanted data, it is not recommended to delete any data from your database because the action cannot be undone. It is better to add another column to your table called status and use that to indicate whether data should be shown or not. For example, if your user deletes data on the front end application, set the status of that data to (let's say) 1 instead of 0. Then, when you want to display data on the front end, display only the data that carries a status of 0:

This way, any data that has been accidentally deleted can be recovered with ease. You can also use a BOOLEAN type for this if you only plan to use true or false. I usually use TINYINT just in case I need a third or fourth status in the future. For more information regarding the DELETE statement, you can refer to the following link:

https://dev.mysql.com/doc/refman/5.7/en/delete.html