Is it partially deleted if a delete operation is performed without a transaction?

Question

If the myTable table contains 100,000,000 records.

And I do DELETE FROM myTable; without starting a transaction, and something is going wrong, for example, a server power failure.

Will some entries be deleted?

Answer 1

Not if the database engine is ACID compliant .

Any one write action is Atomic, contained in an explicit transaction or not.

Aka every write action is a self-contained transaction.

Answer 2

I would say that it will not delete partial ones, but without knowing the database server with which it is difficult for you to say this.