4 ms·
Any CREATE, ALTER or DROP on mysql does an implicit, silent COMMIT (not rollback) before running it. PostgreSQL can do DDL inside a transaction though.
by mst 14y ago
Any CREATE, ALTER or DROP on mysql does an implicit, silent COMMIT (not rollback) before running it.
PostgreSQL can do DDL inside a transaction though.
- MBCook 14y agoYep, that's another one to watch out for. But I'm used to that, it's when an update or delete that can't be reversed I get surprised.
- deleted 14y ago[deleted]