A.7.3 TEMPORARY TABLE problems

The following are a list of the limitations with TEMPORARY TABLES.

• A temporary table can only be of type HEAP, ISAM, MyISAM, MERGE, or InnoDB.
• You can't use temporary tables more than once in the same query. For example, the following doesn't work.

  mysql> SELECT * FROM temporary_table, temporary_table AS t2;
  

• You can't use RENAME on a TEMPORARY table. Note that ALTER TABLE org_name RENAME new_name works!

User Comments

I propose moodss as a useful tool.
Moodss is a modular application. It displays data described and updated in one or more modules, which can be specified in the command
line or dynamically loaded or unloaded while the application is running. Data is originally displayed in tables. Graphical views (graph, bar, 3D pie charts, ...), summary tables (with current, average, minimum and maximum values) and free text viewers can be created from any number of table cells, originating from any of the
displayed viewers. Thresholds can be set on any number of cells.

4 MySQL modules come with the distribution: myvars, mystatus, myprocs and myquery (custom SELECT or SHOW). They can be combined for example with Apache, cpustats and memstats modules to monitor one or more web servers on the sam dashboard.

Complete HTML documentation, source and rpms are available at http://jfontain.free.fr

The phpMyAdmin product has been updated, and the
site on phpwizard.net now points to the new site:
http://www.phpmyadmin.net.

Add your own comment.