can't see temporary table on list/ in hirearchical structure to the left

BubikolRamios's profile image BubikolRamios posted 12 years ago in General Permalink
CREATE TEMPORARY TABLE SplitValues (
splitted VARCHAR(1000) NOT NULL
) ENGINE=MyISAM;

The table is there coz I can select from it, it is just not visible in hirearchical structure (refresh does not help).

Should that be visible or not ?
BubikolRamios's profile image BubikolRamios posted 12 years ago Permalink
same thing: tools/export database as sql

The table is not on list, but I would like to export it.
ansgar's profile image ansgar posted 12 years ago Permalink
Does it show up when you fire SHOW TABLE STATUS?
BubikolRamios's profile image BubikolRamios posted 12 years ago Permalink
No.
ansgar's profile image ansgar posted 12 years ago Permalink
There you have the reason. If temporary tables are excluded in SHOW TABLE STATUS, then HeidiSQL does not show them.

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