How avoid accidental deletion?

Question

How can you know in advance which records will be deleted when performing DELETE?

Answer 1

Replace DELETE with SELECT *, because otherwise the DELETE syntax is similar to the syntax of a simple SELECT.

Answer 2

SQL is created to store data, it cannot be deleted.

Answer 3

Why in advance? Just call it and see what records are missing.

Answer 4

Make DELETE with LIMIT 1: one record is not a pity.