temporary table already exists on second run after query fails on first run
Posted on 2011-09-19
I have a script where I create a temporary table called 'tempticks'.
Occasionally the query fails, and then I get an error when trying to run it later...
table 'tempticks' already exists.
My Question:- Can I do a check for a table prior to creation, or can I 'autodelete' a table (in case it exists) at the start of a mysql query? I really just want my query to be as rock solid as possible.
See my other open questions for the full query, or further details.