Show database information
Shows the CREATE DATABASE statement that creates the given database.
Table displays database name and respective CREATE DATABASE statement.
Lists the non-TEMPORARY tables that are currently open in the table cache.
Table displays database name, where the table is contained, the table name, the number of table locks or lock requests for the table (In_use), and whether the table name is locked.
Shows status of all procedures on the host.
Table contains name of database where procedure is stored, procedure name, procedure type, procedure definer, date when the procedure was last modified, date when the procedure was created, security type (whether procedure executed using the invoker or definer privileges), brief comments, client character set name, collation of the connection character set, database collation.
Lists non-temporary tables in the specified database and provides vary information about each table.
Table contains name of the table, storage engine for the table, version number of the table's .frm file, row-storage format (Fixed, Dynamic, Compressed, Redundant, Compact), number of rows, average row length, length of the data file, maximum length of the data file, length of the index file, Data_free - number of allocated but unused bytes, next AUTO_INCREMENT value, Create_time - time when the table was created, Update_time - time when the data file was last updated, Check_time - time when the table was last checked, the table's character set and collation, the live checksum value (if any), Create_options - extra options used with CREATE TABLE statement, the comment used when creating the table.
Lists all tables of the selected database.
Table displays names of tables stored in the database.
Lists the triggers currently defined for tables in a database.
Table displays trigger name, event that causes trigger activation (INSERT, UPDATE or DELETE), table for which trigger is defined, statement to be executed when trigger is activated, trigger timing (BEFORE or AFTER), Created (currently the value of this column is always NULL), SQL mode in effect when the trigger executes (starting from MySQL ver. 5.0.11), definer - account under which the trigger was created, client character set name, collation of the connection character set, database collation.