9. Delete

If we want to delete a row we must use the combination of words DELETE FROM + the name of the table + a filter.

DELETE FROM [tabla] WHERE [condicionales];

Let's delete a row from Playlist, the one called Audiobooks.

DELETE FROM Playlist WHERE Name = 'Audiobooks';

Or, if we want to be more specific, with its Id.

DELETE FROM Playlist WHERE PlaylistId = 6;

If you do not use WHERE, you will delete all the information in the table!

Solutions