Does it delete partially if execute a delete statement without transaction?

If the table myTable contains 100000000 records.

And I execute DELETE FROM myTable; without begin transaction and somethings go wrong, su开发者_开发知识库ch as server power failure.

Will it delete some of the records?

---

No, if the DB engine conforms to ACID.

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

A.k.a. each write action is a self contained transaction.

---

I would say no it will not delete partial, but without knowing the database server you use it's hard to tell.