"how to rename two tables in one atomic operation in mysql" Code Answer

5

well, easy...

rename table current to current_20151221, next to current;

as is stated in the manual. there it says that it's an atomic operation. just to clear this up, implicit commits have nothing to do with it. that's a different story. that just says, that those statements end an open transaction.

By Diana Nassar on April 8 2022

Answers related to “how to rename two tables in one atomic operation in mysql”

Only authorized users can answer the Search term. Please sign in first, or register a free account.