How can a specific row be deleted from a database?

Deleting a specific row from a database can be done using the SQL query DELETE. For example, if you need to delete a user with a specific id, the query would look like this:

DELETE FROM users WHERE id = 123;

It is important to ensure that the condition in WHERE precisely identifies the row to avoid deleting unintended data. In test automation, such queries can be executed through database drivers or ORM to prepare test data or clean up after tests.