3 ms·
MySQL has transactions for DDL changes since 8.0.
by aseipp 5y ago
MySQL has transactions for DDL changes since 8.0.
- tpetry 5y agoMySQL has atomic ddl, which means if a ddl operation fails it is reverted. But PostgreSQL has really transactional ddl which means you can do ddl operations in a transaction and you can commit/rollback multiple ddl operations at once and not each by it‘s own like MySQL does. https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html