Checking for a table

Posted on 2012-08-15
Last Modified: 2012-08-15

Does anyone know of a way to check for temp tables in MYSQL?  I'm aware of how to do it in MSSQL server, but can't find a solution for MYSQL.  If anyone has any ideas it would be appreciated

Question by:nmarano
    LVL 51

    Accepted Solution

    The closest I've seen is


    .. which isn't quite what you're asking.  Since this is really a mySQL question, not CF, you want to change the question zone so the right experts see your question :)
    LVL 2

    Author Comment

    Hey agx-  I tried it in MYSQL zone and didn't get a response, so figured I'd try it here where some of the experts have used MYSQL
    LVL 51

    Expert Comment

    Ahh, ok.  I would've thought someone there would know :/  What little I've read suggests it may not be supported.  But maybe someone else knows a neat trick I don't :)
    LVL 2

    Author Closing Comment

    This will work for what I need!  Thanks!
    LVL 51

    Expert Comment

    Btw .. if this is for a stored proc, use the IF NOT EXISTS syntax and drop the temp table at the end - and you should be ok.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    The technique is by far very Simple! How we can export the ColdFusion query results to DOC file?  Well before writing this I researched a lot in Internet but did not found a good Answer anyways!  So i thought now i should share my small snippet w…
    PROBLEM: How to add your own buttons to the bottom toolbar with paging info ( result count ). While creating a cfgrid, I ran into an issue where I wanted to embed my own custom buttons where the default ones ( insert / delete / etc… ) are for aes…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now