<div>
Yes. That's the concept. Are you facing any issues?
</div>


Yes. That's the concept. Are you facing any issues?

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


Dear experts,

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?

Thanks

Is the creation of mysql temporary table unique?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.