distal-attribute
distal-attribute
distal-attribute
distal-attribute

Temporary Tables

User, date Message
Written by John Bell
9 months ago
Category: General
8 posts since Sun, 10 Nov 13
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;
Written by John Bell
9 months ago
8 posts since Sun, 10 Nov 13
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.