当它们使用相同的临时表名时，2个MySQL连接是否可能崩溃？

Question

My call sequence to MySQL is like this:

Connection1: 
create temporary table 'temp_table'...

Connection2: 
create temporary table 'temp_table'... (already exists, crash???) 

Connection1: 
drop table 'temp_table'... 

Connection2:
drop table 'temp_table'... (no longer exists, crash???)

Is it possible such a case may happen? Or each connection has its own space for temporary tables so that they (the connections) won't conflict with others?

Answer 1

No; temporary tables are local to the connection that they're created by. They aren't visible to other clients, and separate clients can create temporary tables that shadow each other.