4 ms·
That was added a couple years ago in MySQL 8, as were window functions and arbitrary checks. The two databases continue to fill in the gaps that were historical
by derekperkins 6y ago
That was added a couple years ago in MySQL 8, as were window functions and arbitrary checks. The two databases continue to fill in the gaps that were historically reasons to choose one over the other.
- paulryanrogers 6y agoAre Mysql 8 DDL changes transactional across tables? If not then in what sense are they transactional? Because to this day I still have to deal with locking problems unless my changes are within a narrow window: last column, no on-update or on-delete, not changing type, etc.
- tpetry 6y agoMysql 8 supports atomic ddl, which means if you drop two tables in a single DROP TABLE query either both are deleted or none. But it does not support postgresql‘s transactional ddl feature where you can start a transaction change the structure of multiple tables, change some data etc. and commit at the end. Mysql 8 males ddl changes atomic, but does not support transactional mode where you could rollback them.