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

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

User, date Message
Written by BubikolRamios
2 years ago
Category: General
327 posts since Thu, 14 Jan 10
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 ?
Written by BubikolRamios
2 years ago
327 posts since Thu, 14 Jan 10
same thing: tools/export database as sql

The table is not on list, but I would like to export it.
Written by ansgar
2 years ago
4988 posts since Fri, 07 Apr 06
Does it show up when you fire SHOW TABLE STATUS?
Written by BubikolRamios
2 years ago
327 posts since Thu, 14 Jan 10
No.
Written by ansgar
2 years ago
4988 posts since Fri, 07 Apr 06
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.