[baudehlo]

That's just a limitation of MySQL, not relational databases in general. In Postgres you can do it live in a transaction.