[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 278
  • Last Modified:

Is the creation of mysql temporary table unique?

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
0
Kinderly Wade
Asked:
Kinderly Wade
  • 2
1 Solution
 
sventhanCommented:
Yes. That's the concept. Are you facing any issues?
0
 
sventhanCommented:
You can use the temp table in subsequent calls to the procedure during the same database connection, but other connections cannot access it. They can create a table by the same name, but each temp table will be independent. Temp tables go away when you close your connection.

http://stackoverflow.com/questions/6567730/is-mysql-temporary-table-a-shared-resource
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now