If autocommit is enabled, yes, it will execute atomically. Each operator will be a single transaction unless auto-protection is disabled.
It should be noted that autocommit is on by default, so a START TRANSACTION is usually required to start a transaction.
source
to share