[Tools]  Datenbank: `information_schema`  Tabelle: `PARTITIONS`

         ---               

SELECT * FROM `PARTITIONS`

Die Ausführung von SQL-Befehlen kann Daten manipulieren! Der Autor übernimmt keine Haftung bei Datenverlusten.

Tabellen der Datenbank `information_schema` bearbeiten

Tabelle `PARTITIONS`

Felder der Tabelle `PARTITIONS`

		Field	Type	Size	NULL	Key	Attribute	Default	Extra	Sortierung	Kommentar
	1.	TABLE_CATALOG	varchar	512	nein					utf8_general_ci
	2.	TABLE_SCHEMA	varchar	64	nein					utf8_general_ci
	3.	TABLE_NAME	varchar	64	nein					utf8_general_ci
	4.	PARTITION_NAME	varchar	64	ja					utf8_general_ci
	5.	SUBPARTITION_NAME	varchar	64	ja					utf8_general_ci
	6.	PARTITION_ORDINAL_POSITION	bigint	21	ja		unsigned
	7.	SUBPARTITION_ORDINAL_POSITION	bigint	21	ja		unsigned
	8.	PARTITION_METHOD	varchar	18	ja					utf8_general_ci
	9.	SUBPARTITION_METHOD	varchar	12	ja					utf8_general_ci
	10.	PARTITION_EXPRESSION	longtext		ja					utf8_general_ci
	11.	SUBPARTITION_EXPRESSION	longtext		ja					utf8_general_ci
	12.	PARTITION_DESCRIPTION	longtext		ja					utf8_general_ci
	13.	TABLE_ROWS	bigint	21	nein		unsigned
	14.	AVG_ROW_LENGTH	bigint	21	nein		unsigned
	15.	DATA_LENGTH	bigint	21	nein		unsigned
	16.	MAX_DATA_LENGTH	bigint	21	ja		unsigned
	17.	INDEX_LENGTH	bigint	21	nein		unsigned
	18.	DATA_FREE	bigint	21	nein		unsigned
	19.	CREATE_TIME	datetime		ja
	20.	UPDATE_TIME	datetime		ja
	21.	CHECK_TIME	datetime		ja
	22.	CHECKSUM	bigint	21	ja		unsigned
	23.	PARTITION_COMMENT	varchar	80	nein					utf8_general_ci
	24.	NODEGROUP	varchar	12	nein					utf8_general_ci
	25.	TABLESPACE_NAME	varchar	64	ja					utf8_general_ci

Indizes der Tabelle `PARTITIONS`