3 ms·
I'm not even sure this is possible in mysql. Last time I checked mysql still couldn't do DDL statements in a transaction.
by Doxin 8y ago
I'm not even sure this is possible in mysql. Last time I checked mysql still couldn't do DDL statements in a transaction.
- lloeki 8y agoLast time I checked MySQL even silently commits out of the transaction and proceeds with the remainder of the queries. Here are the "implicit commit" statements: https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
- fredley 8y agoIn Django it doesn't, it just dumps you out with a fucked-up semi-migration that takes you 20 minutes to get back to a consistent state...
- Doxin 8y agoHonestly I don't see a single good reason for any new project to use mysql over postgres. mysql is almost universally terrible at actually being a database.