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

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

BubikolRamios posted 2 years ago in General
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 posted 2 years ago
same thing: tools/export database as sql

The table is not on list, but I would like to export it.
ansgar posted 2 years ago
Does it show up when you fire SHOW TABLE STATUS?
BubikolRamios posted 2 years ago
No.
ansgar posted 2 years ago
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.