I wish to know if the creation of temporary tables in mysql considered as unique?
I know that temporary tables can stay alive as long as the connection is still alive.
For example, there are 5 users currently accessing the mysql database.
If each of these 5 users create a temporary table with same name will there be conflicts among
these temporary tables or these temporary tables with same name will not be affected because
the each temporary table only live within its own connection?