Is the creation of mysql temporary table unique?

Posted on 2014-08-15
Last Modified: 2014-08-15
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?

Question by:Kinderly Wade
    LVL 18

    Expert Comment

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

    Accepted Solution

    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.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
    This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
    This video discusses moving either the default database or any database to a new volume.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now