can't see temporary table on list/ in hirearchical structure to the left
| User, date | Message |
|---|---|
|
Written by BubikolRamios
11 months ago Category: General 275 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
11 months ago 275 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
11 months ago 4027 posts since Fri, 07 Apr 06 |
Does it show up when you fire SHOW TABLE STATUS? |
|
Written by BubikolRamios
11 months ago 275 posts since Thu, 14 Jan 10 |
No. |
|
Written by ansgar
11 months ago 4027 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. |