Deletes all the records FROM

notes

table. This is too dangerous command because there is no undo when it comes to databases. If we update or delete something, the original values are gone.

DELETE FROM notes;

Deletes the row with the specified private key -

id

. We should always use

WHERE

clause, not to delete everything from the database

DELETE FROM `requests` WHERE `id` = '1548630';

Deletes the student with the specified first name and last name

DELETE FROM `requests` WHERE (first_name = 'John' AND last_name = 'Doe');