What happens when a table is dropped at the same time in MySQL?

Question

MySQL

What happens when several users delete (create, record) one table at the same time? Mistake and all? More

Answer 1

The tables are crashing. So it still won't work at the same time.
How and what is locked depends on the type of engine.
Well, you can also force lock yourself if you need LOCK TABLES / UNLOCK TABLES

Answer 2

1) Your server will not explode from such a request, it will not collapse, and the black hole of the universe will not open either - so if you have such questions very often - create yourself a virtual machine with a server that is not a pity and conduct experiments on it. Yes, you can come up with a set of scripts that will cause deadlock, but your instruction does not apply to those.
2) Why? It's just - why???? What is your programming or development logic that simultaneously (!!!) executes two queries like DROP TABLE, CREATE TABLE and so on. If you dynamically add tables to the database, then with each such table in the world another cute kitten starts to cry, and personally I have a stronger desire to become a maniac. No need for program logic to create new tables. There is no problem that requires such a solution. The database schema should be EXTREMELY static. Yes, changes are made, but only cosmetic and only by one specific script during the update of your application.