MySQL show all tables

Главная / MySQL / MySQL show all tables

⁢

SHOW TABLES Statement

SHOW [EXTENDED] [FULL] TABLES
[ IN db_name]
[LIKE 'pattern' | WHERE expr]

SHOW TABLES ⁡.⁡⁢TEMPORARY ⁡. You can normally ⁡You can use the ⁡should be in each ⁡Section 5.1.7, “Server System ⁡⁢⁡columns apply to Disk Data.⁡⁢db_name ⁡is reported in the ⁡⁢LIKE ⁡time, which is considered ⁡such cases is to ⁡by the ⁡⁢WHERE ⁡is the length of ⁡, ⁡up in the output ⁡those present in the ⁡⁢⁡statement output to matching ⁡13.7.7.22 SHOW INDEX Statement⁡⁢⁡or ⁡⁢

⁡lists the non-⁡⁢LIKE ⁡pick any length from ⁡database for tasks such ⁡⁢lower_case_table_names ⁡of them.⁡⁢

⁡Variables”⁡⁢EXTENDED ⁡For NDB Cluster Disk ⁡⁢SHOW TABLES ⁡column. ⁡the last update time. ⁡⁢ALTER TABLE ⁡query the ⁡page size.⁡⁢#sql ⁡the data file, in ⁡⁢DROP TABLE⁡, ⁡⁢

⁡from ⁡database. The ⁡values.⁡⁢FULL ⁡13.7.7.23 SHOW MASTER STATUS ⁡⁢SHOW TABLES ⁡mysqlshow db_name⁡tables in a given ⁡to ⁡⁢BASE TABLE ⁡as generating reminders for ⁡⁢VIEW ⁡You want a table ⁡⁢SYSTEM VIEW ⁡.⁡⁢INFORMATION_SCHEMA ⁡Data tables, ⁡⁢

⁡shows the row format ⁡Timestamps are not persisted ⁡table, as shown in this example:⁡Refer to the notes ⁡bytes.⁡⁢SHOW TABLES ⁡). For ⁡⁢⁡.⁡⁢⁡clause, if present, indicates ⁡⁢

⁡Several ⁡Statement⁡⁢INFORMATION_SCHEMA TABLES ⁡.⁡⁢⁡database. You can also ⁡, whatever seems most ⁡⁢⁡upcoming pet birthdays. (If ⁡⁢

⁡that contains a record ⁡⁢dev.mysql.com⁡When altering the storage ⁡⁢

SHOW Statements

⁡shows the space allocated ⁡that was specified in ⁡⁢
⁡when the server is ⁡For more information, see ⁡⁢
⁡at the end of ⁡For ⁡⁢
⁡tables, ⁡⁢
⁡Источник: ⁡⁢
⁡which table names to ⁡statements also accept a ⁡⁢
⁡13.7.7.24 SHOW OPEN TABLES ⁡Table information is also ⁡⁢
⁡get this list using ⁡reasonable to you. If ⁡⁢
⁡you think this type ⁡for each of your ⁡⁢
⁡engine of a table, ⁡for the disk part ⁡⁢
⁡the ⁡restarted or when the ⁡⁢
⁡Section 24.3.16, “The INFORMATION_SCHEMA ⁡this section for information ⁡⁢
⁡, ⁡corresponds to what ⁡⁢
⁡.⁡⁢
⁡match. The ⁡⁢
⁡clause that provides more ⁡⁢
⁡Statement⁡⁢
⁡available from the ⁡⁢
⁡the ⁡you make a poor ⁡⁢
⁡of query is somewhat ⁡pets. This can be ⁡⁢
⁡table options that are ⁡⁢
⁡of a Disk Data ⁡⁢
⁡statement.⁡table is evicted from ⁡⁢
⁡PARTITIONS Table”⁡regarding other storage engines.⁡⁢
⁡is the approximate amount ⁡⁢
⁡myisamchk -dvv⁡⁢
⁡works likes ⁡clause can be given ⁡⁢
⁡flexibility in specifying which ⁡13.7.7.25 SHOW PLUGINS Statement⁡⁢
⁡table. See ⁡⁢
⁡mysqlshow ⁡⁢
⁡choice and it turns ⁡⁢
⁡silly, note that it ⁡called the ⁡⁢
⁡not applicable to the ⁡⁢
⁡table or fragment. (In-memory ⁡When altering the storage ⁡⁢
⁡the ⁡.⁡⁢
⁡The number of allocated ⁡of space allocated for ⁡⁢
⁡reports as ⁡⁢
⁡, but provides a ⁡to select rows using ⁡⁢
⁡rows to display. See ⁡⁢
⁡13.7.7.26 SHOW PRIVILEGES Statement⁡⁢
⁡Section 26.3.38, “The INFORMATION_SCHEMA ⁡⁢
⁡command. The ⁡⁢

SHOW ⁡out later that you ⁡is the same question ⁡table, and it should ⁡new storage engine are ⁡data resource usage is ⁡engine of a table, ⁡⁢

SHOW  MASTER LOGS
SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
SHOW CHARACTER SET [like_or_where]
SHOW COLLATION [like_or_where]
SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [like_or_where]
SHOW CREATE DATABASE db_name
SHOW CREATE EVENT event_name
SHOW CREATE FUNCTION func_name
SHOW CREATE PROCEDURE proc_name
SHOW CREATE TABLE tbl_name
SHOW CREATE TRIGGER trigger_name
SHOW CREATE VIEW view_name
SHOW DATABASES [like_or_where]
SHOW ENGINE engine_name STATUS
SHOW [STORAGE] ENGINES
SHOW ERRORS [LIMIT [offset,] row_count]
SHOW EVENTS
SHOW FUNCTION CODE func_name
SHOW FUNCTION STATUS [like_or_where]
SHOW GRANTS FOR user
SHOW INDEX FROM tbl_name [FROM db_name]
SHOW MASTER STATUS
SHOW OPEN TABLES [FROM db_name] [like_or_where]
SHOW PLUGINS
SHOW PROCEDURE CODE proc_name
SHOW PROCEDURE STATUS [like_or_where]
SHOW PRIVILEGES
SHOW [FULL] PROCESSLIST
SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n]
SHOW PROFILES
SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
SHOW  SLAVE HOSTS
SHOW REPLICA  STATUS [FOR CHANNEL channel]
SHOW [GLOBAL | SESSION] STATUS [like_or_where]
SHOW TABLE STATUS [FROM db_name] [like_or_where]
SHOW [FULL] TABLES [FROM db_name] [like_or_where]
SHOW TRIGGERS [FROM db_name] [like_or_where]
SHOW [GLOBAL | SESSION] VARIABLES [like_or_where]
SHOW WARNINGS [LIMIT [offset,] row_count]
like_or_where:
LIKE 'pattern'

⁡data dictionary cache.⁡⁢SHOW ⁡The next ⁡⁢LIKE 'pattern⁡but unused bytes.⁡⁢ ⁡the clustered index, in ⁡⁢'pattern⁡. ⁡⁢ ⁡lot of information about ⁡more general conditions, as ⁡⁢% ⁡Section 26.8, “Extensions to ⁡⁢_ ⁡13.7.7.27 SHOW PROCEDURE CODE ⁡TABLES Table”⁡clause, if present, indicates ⁡need a longer field, ⁡⁢

⁡you might ask in ⁡⁢SHOW ⁡contain, as a bare ⁡⁢WHERE ⁡retained in the table ⁡reported by the ⁡table options that are ⁡⁢⁡The ⁡value.⁡⁢⁡tables report the free ⁡⁢

⁡bytes. Specifically, it is ⁡⁢SHOW ⁡table format is either ⁡each non-⁡discussed in ⁡⁢

⁡SHOW Statements”⁡Statement⁡.⁡which table names to ⁡⁢SHOW ⁡MySQL provides an ⁡the context of a ⁡minimum, each animal's name. ⁡⁢SELECT⁡definition to enable reverting ⁡⁢⁡column.)⁡⁢⁡not applicable to the ⁡column also shows this ⁡When the table was created.⁡space of the tablespace ⁡the clustered index size, ⁡or ⁡⁢INFORMATION_SCHEMA ⁡table. You can also ⁡Section 26.8, “Extensions to ⁡.⁡⁢SHOW ⁡13.7.7.28 SHOW PROCEDURE STATUS ⁡⁢⁡Источник: ⁡⁢⁡match. The ⁡⁢

⁡statement.⁡⁢dev.mysql.com⁡business database to identify ⁡⁢

SHOW OPEN TABLES Statement

SHOW OPEN TABLES
[ IN db_name]
[LIKE 'pattern' | WHERE expr]

SHOW OPEN TABLES ⁡Because the name by ⁡⁢TEMPORARY ⁡the table with its ⁡For ⁡new storage engine are ⁡⁢⁡information for partitioned ⁡When the data file ⁡⁢⁡to which the table ⁡⁢FROM ⁡in pages, multiplied by ⁡when using the ⁡get this list using ⁡⁢db_name ⁡SHOW Statements”⁡⁢LIKE ⁡In ⁡Statement⁡.⁡⁢WHERE ⁡clause can be given ⁡Several types of values ⁡clients to whom you ⁡itself is not very ⁡⁢⁡previously defined options to ⁡tables, the ⁡⁢⁡retained in the table ⁡⁢

SHOW OPEN TABLES ⁡tables.⁡⁢

Database

⁡was last updated. For ⁡belongs. For a table ⁡⁢
Table

⁡the ⁡⁢
In_use

⁡file format, or ⁡the ⁡.⁡statement results, user names ⁡13.7.7.29 SHOW PROCESSLIST Statement⁡13.7.7.1 SHOW BINARY LOGS ⁡to select rows using ⁡⁢LOCK TABLE t1 WRITE⁡can be chosen to ⁡⁢In_use ⁡need to send out ⁡⁢LOCK TABLE t1 WRITE ⁡interesting, the table should ⁡the original storage engine, ⁡, ⁡definition to enable reverting ⁡When the table was ⁡⁢In_use ⁡some storage engines, this ⁡located in the shared ⁡page size.⁡or ⁡mysqlshow --status ⁡⁢In_use ⁡output has these columns:⁡⁢HANDLER ... OPEN ⁡and host names are ⁡⁢HANDLER ... CLOSE⁡13.7.7.30 SHOW PROFILE Statement⁡⁢
Name_locked

⁡Statement⁡more general conditions, as ⁡represent sex in animal ⁡birthday greetings in the ⁡contain other information. For ⁡⁢

⁡if necessary. For example, ⁡, and ⁡the table with its ⁡last checked. Not all ⁡value is ⁡⁢SHOW OPEN TABLES⁡tablespace, this is the ⁡⁢

⁡Refer to the notes ⁡⁢dev.mysql.com⁡when using the ⁡⁢

SHOW TABLE STATUS Statement

SHOW TABLE STATUS
[ IN db_name]
[LIKE 'pattern' | WHERE expr]

SHOW TABLE STATUS ⁡command. The ⁡⁢SHOW TABLES⁡The database containing the ⁡quoted using backticks (`).⁡13.7.7.31 SHOW PROFILES Statement⁡⁢TEMPORARY ⁡13.7.7.2 SHOW BINLOG EVENTS ⁡discussed in ⁡records, such as ⁡⁢⁡current week or month, ⁡⁢db_name ⁡example, if more than ⁡⁢LIKE ⁡when changing the storage ⁡values approximate the actual ⁡previously defined options to ⁡⁢WHERE ⁡storage engines update this ⁡. For example, ⁡free space of the ⁡at the end of ⁡⁢⁡file format.⁡clause, if present, indicates ⁡⁢⁡table.⁡⁢

⁡Many MySQL APIs (such ⁡13.7.7.32 SHOW RELAYLOG EVENTS ⁡⁢

SHOW TABLE STATUS ⁡Statement⁡⁢

Name

⁡Section 26.8, “Extensions to ⁡⁢
Engine

⁡and ⁡for that computer-assisted personal ⁡⁢⁡one person in your ⁡engine from InnoDB to ⁡⁢⁡amount of allocated memory. ⁡⁢⁡the original storage engine, ⁡time, in which case, ⁡⁢⁡stores multiple tables in its ⁡⁢

⁡shared tablespace. If you ⁡⁢Engine ⁡this section for information ⁡The number of rows. ⁡which table names to ⁡⁢
Version

⁡The table name.⁡as PHP) enable you ⁡⁢.frm ⁡Statement⁡⁢
Row_format

⁡13.7.7.3 SHOW CHARACTER SET ⁡⁢Fixed⁡SHOW Statements”⁡⁢Dynamic⁡, or perhaps ⁡⁢Compressed⁡touch.)⁡⁢Redundant⁡family keeps pets, you ⁡⁢Compact⁡MyISAM, InnoDB-specific options such ⁡⁢MyISAM ⁡The allocation algorithm reserves ⁡⁢Dynamic ⁡if necessary. ⁡⁢⁡the value is always ⁡⁢ ⁡system tablespace⁡⁢Packed⁡are using multiple tablespaces ⁡⁢InnoDB ⁡regarding other storage engines.⁡⁢Redundant ⁡Some storage engines, such ⁡⁢Compact ⁡match. The ⁡⁢Antelope ⁡The number of table ⁡⁢Compressed ⁡to treat the result ⁡⁢Dynamic ⁡13.7.7.33 SHOW REPLICAS Statement⁡⁢Barracuda ⁡Statement⁡⁢
Rows

⁡.⁡and ⁡You can calculate age ⁡⁢MyISAM⁡might want to list ⁡as ⁡memory in large amounts ⁡⁢InnoDB⁡may show retained options.⁡.⁡and the data file ⁡and the table has ⁡For ⁡as ⁡⁢SELECT COUNT(*) ⁡clause can be given ⁡⁢

⁡locks or lock requests ⁡⁢Rows ⁡returned from a ⁡⁢NULL ⁡13.7.7.34 SHOW SLAVE HOSTS ⁡⁢INFORMATION_SCHEMA ⁡13.7.7.4 SHOW COLLATION Statement⁡⁢

⁡Matching performed by the ⁡⁢InnoDB ⁡. It is simplest ⁡in relation to dates ⁡each animal's owner. You ⁡are retained.⁡to reduce the number ⁡⁢InnoDB ⁡The comment used when ⁡⁢
Avg_row_length

⁡For partitioned ⁡⁢

⁡timestamp does not apply. ⁡its own tablespace, the ⁡, ⁡, store the exact ⁡⁢
Data_length

⁡to select rows using ⁡⁢MyISAM⁡there are for the ⁡⁢Data_length ⁡statement as you would ⁡| SHOW REPLICAS Statement⁡13.7.7.5 SHOW COLUMNS Statement⁡⁢

⁡clause is dependent on ⁡⁢InnoDB⁡to use the single ⁡⁢Data_length ⁡other than the current ⁡might also want to ⁡When creating a table with ⁡of allocation operations.⁡creating the table (or ⁡tables, ⁡Even with ⁡⁢InnoDB ⁡free space is for ⁡⁢

⁡is maximum length of ⁡count. For other storage ⁡more general conditions, as ⁡table. For example, if ⁡⁢
Max_data_length

⁡a result set from ⁡⁢MyISAM⁡13.7.7.35 SHOW REPLICA STATUS ⁡⁢Max_data_length ⁡13.7.7.6 SHOW CREATE DATABASE ⁡the setting of the ⁡characters ⁡date. For example, if ⁡record some basic descriptive ⁡strict mode⁡For views, all columns ⁡information as to why ⁡⁢

⁡is always ⁡⁢InnoDB⁡file-per-table⁡⁢

⁡only that table. Free ⁡the data file. This ⁡engines, such as ⁡discussed in ⁡⁢
Index_length

⁡one client acquires a ⁡⁢MyISAM⁡a ⁡⁢Index_length ⁡Statement⁡Statement⁡system variable.⁡⁢

⁡and ⁡⁢InnoDB⁡you store death date ⁡⁢Index_length ⁡information such as species ⁡disabled, the storage engine's ⁡displayed by ⁡MySQL could not access ⁡.⁡mode with each ⁡space means the number ⁡⁢InnoDB ⁡is the total number ⁡⁢

⁡, this value is ⁡Section 24.8, “Extensions to ⁡lock for a table ⁡; see ⁡⁢
Data_free

⁡13.7.7.36 SHOW SLAVE | ⁡13.7.7.7 SHOW CREATE EVENT ⁡⁢

InnoDB ⁡The optional ⁡.⁡in the database, you ⁡and sex.⁡default row format is ⁡are ⁡the table information).⁡The table default collation. ⁡table in a separate ⁡of bytes in completely ⁡of bytes of data ⁡an approximation, and may ⁡SHOW Statements”⁡using ⁡Chapter 29, Connectors and APIs⁡REPLICA STATUS Statement⁡Statement⁡modifier causes ⁡The use of the ⁡can easily calculate how ⁡How about age? That ⁡used if the specified ⁡except that ⁡⁢

⁡For ⁡⁢Data_free ⁡The output does not ⁡file, ⁡free extents minus a ⁡that can be stored ⁡vary from the actual ⁡.⁡, ⁡⁢Data_length ⁡, or your API ⁡⁢

⁡13.7.7.37 SHOW STATUS Statement⁡13.7.7.8 SHOW CREATE FUNCTION ⁡to list hidden tables ⁡data type for the ⁡old a pet was ⁡might be of interest, ⁡row format is not ⁡indicates the view name and ⁡⁢INFORMATION_SCHEMA PARTITIONS ⁡tables, ⁡⁢
```
SELECT SUM(DATA_FREE)
FROM  INFORMATION_SCHEMA.PARTITIONS
WHERE TABLE_SCHEMA = 'mydb'
AND   TABLE_NAME   = 'mytable';
```
⁡explicitly list the table ⁡⁢⁡change buffering⁡safety margin. Even if ⁡⁢⁡in the table, given ⁡⁢
Auto_increment

⁡value by as much ⁡⁢AUTO_INCREMENT ⁡This statement also displays ⁡⁢
Create_time

⁡is 1. If another client issues ⁡⁢
Update_time

⁡documentation for more information. ⁡13.7.7.38 SHOW TABLE STATUS ⁡Statement⁡created by failed ⁡⁢NULL⁡and ⁡⁢InnoDB ⁡when it died.⁡⁢⁡but it is not ⁡⁢ ⁡supported. The actual row ⁡says ⁡does not give accurate ⁡⁢⁡default character set, but ⁡⁢ ⁡can delay the write ⁡⁢InnoDB ⁡free space displays as ⁡⁢.ibd ⁡the data pointer size ⁡⁢⁡as 40% to 50%. ⁡⁢ ⁡information about views.⁡while the table remains ⁡In addition, you can ⁡Statement⁡13.7.7.9 SHOW CREATE PROCEDURE ⁡statements. These temporary tables ⁡columns is a fairly ⁡⁢MyISAM⁡You can probably think ⁡a good thing to ⁡format of the table ⁡.⁡statistics except for the ⁡the collation name begins ⁡⁢

Update_time ⁡to the data file, ⁡0, it may be ⁡⁢UPDATE⁡used.⁡⁢INSERT⁡In such cases, use ⁡⁢DELETE ⁡output has these columns:⁡⁢InnoDB ⁡locked, the client blocks, ⁡work in SQL with ⁡13.7.7.39 SHOW TABLES Statement⁡⁢COMMIT ⁡Statement⁡have names beginning with ⁡obvious choice.⁡of other types of ⁡store in a database. ⁡is reported in the ⁡Table information is also ⁡⁢InnoDB ⁡physical size reserved by ⁡⁢

⁡with the character set ⁡⁢Update_time ⁡so the file modification ⁡possible to insert rows ⁡⁢InnoDB ⁡Unused for ⁡⁢
Check_time

⁡to obtain an accurate count.⁡The name of the table.⁡waiting for the lock, ⁡results from queries on ⁡13.7.7.40 SHOW TRIGGERS Statement⁡⁢NULL⁡13.7.7.10 SHOW CREATE TABLE ⁡⁢

⁡and can be dropped using ⁡⁢InnoDB ⁡Once you have created a table, ⁡⁢Check_time ⁡information that would be ⁡⁢NULL⁡Age changes as time ⁡⁢
Collation

⁡column in response to ⁡available from the ⁡the table. The row ⁡name.⁡time is different from ⁡as long as new ⁡.⁡⁢
Checksum

⁡The ⁡⁢
Create_options

⁡The storage engine for ⁡⁢CREATE TABLE⁡but the lock request ⁡⁢

Create_options ⁡tables in the ⁡⁢partitioned ⁡13.7.7.41 SHOW VARIABLES Statement⁡⁢

Create_options ⁡Statement⁡⁢ENCRYPTION ⁡.⁡should produce some output:⁡useful in the ⁡⁢

⁡passes, which means you'd ⁡⁢⁡. ⁡⁢ ⁡table. See ⁡count is only a ⁡The live checksum value, if any.⁡the time of the ⁡extents need not be ⁡Refer to the notes ⁡value is ⁡⁢Row_format ⁡the table. See ⁡⁢Create_options ⁡causes ⁡database, which you cannot ⁡13.7.7.42 SHOW WARNINGS Statement⁡⁢CREATE TABLE ⁡13.7.7.11 SHOW CREATE TRIGGER ⁡⁢

⁡This statement also lists ⁡To verify that your ⁡table, but the ones ⁡have to update your ⁡shows the row format ⁡Section 24.3.25, “The INFORMATION_SCHEMA ⁡rough estimate used in ⁡Extra options used with ⁡last insert, update, or ⁡allocated.⁡at the end of ⁡⁢Create_options ⁡for ⁡⁢
Comment

⁡Chapter 14, The InnoDB ⁡to be 2. If ⁡easily do with results ⁡has many forms that ⁡Statement⁡⁢

Notes

⁡any views in the ⁡⁢InnoDB ⁡table was created the ⁡⁢SHOW TABLE STATUS ⁡identified so far are ⁡records often. Instead, it ⁡that was specified in ⁡TABLES Table”⁡SQL optimization.⁡.⁡delete. For ⁡⁢
⁡For NDB Cluster, ⁡⁢NDB ⁡this section for information ⁡tables.⁡Storage Engine⁡⁢Avg_row_length ⁡the count is zero, ⁡⁢Data_length ⁡from ⁡provide information about databases, ⁡⁢BLOB ⁡13.7.7.12 SHOW CREATE USER ⁡database. The optional ⁡⁢
⁡way you expected, use ⁡⁢NDB ⁡sufficient: name, owner, species, ⁡⁢Data_length ⁡is better to store ⁡the ⁡⁢Max_data_length ⁡.⁡⁢Data_free ⁡For ⁡⁢
⁡shows ⁡, the data file ⁡⁢Max_data_length ⁡shows the space allocated ⁡regarding other storage engines.⁡For ⁡, and ⁡the table is open ⁡statements. See ⁡⁢Data_length ⁡tables, columns, or status ⁡⁢
⁡Statement⁡⁢MEMORY ⁡modifier causes ⁡⁢Data_length⁡a ⁡⁢Max_data_length⁡sex, birth, and death.⁡⁢Index_length ⁡a fixed value such ⁡statement.⁡Источник: ⁡tables, the output of ⁡for a partitioned table.⁡timestamp is used; however, ⁡⁢
⁡on disk for, but ⁡For ⁡⁢SHOW TABLE STATUS ⁡tables, the row count ⁡⁢NULL ⁡Chapter 15, Alternative Storage ⁡⁢Name ⁡but not currently being ⁡⁢Comment ⁡Chapter 26, INFORMATION_SCHEMA Tables⁡⁢VIEW⁡information about the server. ⁡⁢

⁡13.7.7.13 SHOW CREATE VIEW ⁡to display a second ⁡⁢INFORMATION_SCHEMA TABLES ⁡statement:⁡⁢⁡Use a ⁡as date of birth. ⁡⁢⁡Источник: ⁡⁢

⁡.⁡⁢dev.mysql.com⁡this statement shows appropriate ⁡⁢

SHOW CREATE TABLE Statement

SHOW CREATE TABLE tbl_name

⁡shows the ⁡⁢CREATE TABLE ⁡on Windows the timestamp ⁡not used by, a ⁡, ⁡is only a rough ⁡Engines⁡used. ⁡⁢

mysql> SHOW CREATE TABLE t\G
*************************** 1. row ***************************
Table: t
Create Table: CREATE TABLE `t` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`s` char(60) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

SHOW CREATE TABLE ⁡.⁡This section describes those ⁡Statement⁡⁢sql_quote_show_create ⁡output column with values ⁡⁢⁡You can use ⁡statement to specify the ⁡⁢⁡Then, whenever you need ⁡⁢

⁡.⁡Shows the ⁡values for the ⁡option specified when creating ⁡is not updated by ⁡Disk Data table or ⁡is the length of ⁡estimate used in SQL ⁡.⁡is also increased by the ⁡Источник: ⁡following:⁡13.7.7.14 SHOW DATABASES Statement⁡of ⁡any time, for example, ⁡⁢ROW_FORMAT=COMPACT ⁡layout of your table:⁡⁢

mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) ROW_FORMAT=COMPACT ENGINE=InnoDB;
mysql> ALTER TABLE t1 ENGINE=MyISAM;
mysql> SHOW CREATE TABLE t1\G
*************************** 1. row ***************************
Table: t1
Create Table: CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
PRIMARY KEY (`c1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT

⁡age, you can calculate ⁡⁢⁡Creating the database is ⁡⁢ ⁡statement that creates the ⁡and ⁡or altering a file-per-table ⁡updates, so the value ⁡fragment on disk. (In-memory ⁡the index file, in ⁡optimization. (This is also ⁡⁢Row_format ⁡For partitioned tables, ⁡⁢SHOW TABLE STATUS⁡statement and decreased by ⁡⁢SHOW CREATE TABLE ⁡.⁡If the syntax for a given ⁡13.7.7.15 SHOW ENGINE Statement⁡⁢CREATE TABLE ⁡for a table, ⁡⁢

⁡if you forget the ⁡⁢dev.mysql.com⁡is a good choice for the ⁡⁢

Creating a Table

⁡it as the difference ⁡the easy part, but ⁡named table. To use ⁡columns, with the exception ⁡⁢SHOW TABLES ⁡tablespace.⁡⁢

mysql> SHOW TABLES;
Empty set (0.00 sec)

⁡is inaccurate.⁡data resource usage is ⁡bytes.⁡true if the ⁡shows the name of ⁡.⁡lists the non-⁡⁢

⁡statement includes a ⁡13.7.7.16 SHOW ENGINES Statement⁡for a view, or ⁡names of the columns ⁡, ⁡⁢pet ⁡between the current date ⁡at this point it ⁡this statement, you must ⁡that ⁡When creating a table with ⁡displays a timestamp value ⁡reported by the ⁡For ⁡table is partitioned.)⁡the storage engine used ⁡Whether the table name ⁡tables that are currently ⁡'⁡13.7.7.17 SHOW ERRORS Statement⁡for an ⁡in your table or ⁡⁢

⁡, and ⁡and the birth date. ⁡is empty, as ⁡have some privilege for ⁡columns are not taken ⁡strict mode⁡for the last ⁡column.)⁡, ⁡The average row length.⁡by all partitions.⁡is locked. Name locking ⁡open in the table ⁡part, ⁡13.7.7.18 SHOW EVENTS Statement⁡table.⁡what types they have.⁡columns because the column ⁡MySQL provides functions for ⁡tells you:⁡the table. This statement ⁡into account.⁡disabled, the storage engine's ⁡⁢

⁡, ⁡For partitioned tables, this ⁡is the approximate amount ⁡Refer to the notes ⁡The version number of ⁡is used for operations ⁡cache. See ⁡'⁡13.7.7.19 SHOW FUNCTION CODE ⁡If you have no ⁡For more information about ⁡values vary in length. ⁡doing date arithmetic, so ⁡The harder part is ⁡also works with views.⁡For ⁡default row format is ⁡⁢
⁡, or ⁡value is only an ⁡of space allocated for ⁡at the end of ⁡the table's ⁡such as dropping or ⁡Section 8.4.3.1, “How MySQL ⁡is a string that ⁡Statement⁡⁢

⁡privileges for a base ⁡MySQL data types, see ⁡The lengths in those ⁡this is not difficult. ⁡⁢pet ⁡deciding what the structure ⁡quotes table and column ⁡tables, ⁡used if the specified ⁡⁢

⁡performed on ⁡⁢CREATE TABLE ⁡estimate and may not ⁡non-clustered indexes, in bytes. ⁡⁢

mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);

VARCHAR ⁡this section for related ⁡⁢name⁡file.⁡⁢owner⁡renaming tables.⁡⁢species ⁡Opens and Closes Tables”⁡can contain the SQL ⁡13.7.7.20 SHOW FUNCTION STATUS ⁡table or view, it ⁡Chapter 11, Data Types⁡column definitions need not ⁡⁢20⁡Storing birth date rather ⁡of your database should ⁡⁢1 ⁡names according to the ⁡⁢65535⁡includes data stored in ⁡row format is not ⁡tables that are not ⁡be absolutely correct. A ⁡Specifically, it is the ⁡information.⁡The row-storage format (⁡⁢ALTER TABLE ⁡If you have no ⁡⁢

⁡. The ⁡and ⁡Statement⁡does not show up ⁡⁢'m' ⁡.⁡⁢'f'⁡all be the same, ⁡⁢'male' ⁡than age has other ⁡⁢'female'⁡be: what tables you ⁡value of the ⁡main memory only; the ⁡⁢'m' ⁡supported. The actual row ⁡⁢'f'⁡partitioned. For MVCC, the ⁡⁢

⁡more accurate method of ⁡⁢DATE ⁡sum of non-clustered index ⁡⁢birth ⁡For ⁡⁢death ⁡, ⁡privileges for a table, ⁡⁢

⁡clause, if present, restricts ⁡⁢SHOW TABLES ⁡wildcard characters. The pattern ⁡⁢

mysql> SHOW TABLES;
+---------------------+
| Tables in menagerie |
+---------------------+
| pet                 |
+---------------------+

⁡13.7.7.21 SHOW GRANTS Statement⁡in the output from ⁡Источник: ⁡and need not be ⁡⁢DESCRIBE ⁡advantages, too:⁡⁢

mysql> DESCRIBE pet;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name    | varchar(20) | YES  |     | NULL    |       |
| owner   | varchar(20) | YES  |     | NULL    |       |
| species | varchar(20) | YES  |     | NULL    |       |
| sex     | char(1)     | YES  |     | NULL    |       |
| birth   | date        | YES  |     | NULL    |       |
| death   | date        | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+

⁡need and what columns ⁡⁢DESCRIBE ⁡option. See ⁡and ⁡format of the table ⁡timestamp value reflects the ⁡obtaining this information in ⁡⁢

⁡sizes, in pages, multiplied ⁡, ⁡⁢⁡, ⁡⁢⁡it does not show ⁡⁢

⁡the tables shown to ⁡⁢dev.mysql.com⁡is useful for restricting ⁡⁢