?
Solved

Checking for a table

Posted on 2012-08-15
5
Medium Priority
?
341 Views
Last Modified: 2012-08-15
Experts-

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

Thanks
nick
0
Comment
Question by:nmarano
  • 3
  • 2
5 Comments
 
LVL 52

Accepted Solution

by:
_agx_ earned 2000 total points
ID: 38298329
The closest I've seen is

         CREATE TEMPORARY TABLE IF NOT EXISTS ....

.. 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 :)
0
 
LVL 2

Author Comment

by:nmarano
ID: 38298720
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
0
 
LVL 52

Expert Comment

by:_agx_
ID: 38298747
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 :)
0
 
LVL 2

Author Closing Comment

by:nmarano
ID: 38298807
This will work for what I need!  Thanks!
0
 
LVL 52

Expert Comment

by:_agx_
ID: 38299142
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.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

850 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