Temporary Tables

John Bell's profile image John Bell posted 11 years ago in General Permalink
i am using mysql 5.5 and heidisql portable 8.1.0.4545. i get a weird warning if i run a query like:

Drop Temporary Table If Exists `Answer`;
Create Temporary Table `Answer`
select Id from Clinics

the following "warning" then pops up
---------------------------
Warning
---------------------------
Your query produced 1 warnings.

Warnings from last query:
---------------------------
OK
---------------------------

the bottom pane (called ?) shows
Drop Temporary Table If Exists `Answer`;
Create Temporary Table `Answer`
select Id from Clinics;
/* Affected rows: 28 Found rows: 0 Warnings: 1 Duration for 2 queries: 0.063 sec. */
SHOW WARNINGS LIMIT 5;
John Bell's profile image John Bell posted 11 years ago Permalink
and btw, if i run the query again, i get no warning so maybe it has to do with the drop and the table not existing???

Please login to leave a reply, or register at first.