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

         ---               

SELECT * FROM `STATISTICS`

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

Daten-Ansicht

Datensatz einfügen    Tabellenstruktur bearbeiten

Tabelle `information_schema`.`STATISTICS`
Datensätze 1 - 30 von insgesamt 219    <<    <    >    >>

Ansicht: kompakt   Die Abfrage enthält 17 Spalten
	#	TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	NON_UNIQUE	INDEX_SCHEMA	INDEX_NAME	SEQ_IN_INDEX	COLUMN_NAME	COLLATION	CARDINALITY	SUB_PART	PACKED	NULLABLE	INDEX_TYPE	COMMENT	INDEX_COMMENT	IGNORED
	1.	def	test	wp_terms	0	test	PRIMARY	1	term_id	A	0	NULL	NULL		BTREE			NO
	2.	def	test	wp_terms	1	test	slug	1	slug	A	0	191	NULL		BTREE			NO
	3.	def	test	wp_terms	1	test	name	1	name	A	0	191	NULL		BTREE			NO
	4.	def	test	wp_usermeta	0	test	PRIMARY	1	umeta_id	A	18	NULL	NULL		BTREE			NO
	5.	def	test	wp_usermeta	1	test	user_id	1	user_id	A	2	NULL	NULL		BTREE			NO
	6.	def	test	wp_usermeta	1	test	meta_key	1	meta_key	A	18	191	NULL	YES	BTREE			NO
	7.	def	test	wp_options	0	test	PRIMARY	1	option_id	A	165	NULL	NULL		BTREE			NO
	8.	def	test	wp_options	0	test	option_name	1	option_name	A	165	NULL	NULL		BTREE			NO
	9.	def	test	wp_options	1	test	autoload	1	autoload	A	4	NULL	NULL		BTREE			NO
	10.	def	test	wp_links	0	test	PRIMARY	1	link_id	A	0	NULL	NULL		BTREE			NO
	11.	def	test	wp_links	1	test	link_visible	1	link_visible	A	0	NULL	NULL		BTREE			NO
	12.	def	test	wp_term_taxonomy	0	test	PRIMARY	1	term_taxonomy_id	A	0	NULL	NULL		BTREE			NO
	13.	def	test	wp_term_taxonomy	0	test	term_id_taxonomy	1	term_id	A	0	NULL	NULL		BTREE			NO
	14.	def	test	wp_term_taxonomy	0	test	term_id_taxonomy	2	taxonomy	A	0	NULL	NULL		BTREE			NO
	15.	def	test	wp_term_taxonomy	1	test	taxonomy	1	taxonomy	A	0	NULL	NULL		BTREE			NO
	16.	def	test	wp_termmeta	0	test	PRIMARY	1	meta_id	A	0	NULL	NULL		BTREE			NO
	17.	def	test	wp_termmeta	1	test	term_id	1	term_id	A	0	NULL	NULL		BTREE			NO
	18.	def	test	wp_termmeta	1	test	meta_key	1	meta_key	A	0	191	NULL	YES	BTREE			NO
	19.	def	test	wp_users	0	test	PRIMARY	1	ID	A	0	NULL	NULL		BTREE			NO
	20.	def	test	wp_users	1	test	user_login_key	1	user_login	A	0	NULL	NULL		BTREE			NO
	21.	def	test	wp_users	1	test	user_nicename	1	user_nicename	A	0	NULL	NULL		BTREE			NO
	22.	def	test	wp_users	1	test	user_email	1	user_email	A	0	NULL	NULL		BTREE			NO
	23.	def	test	wp_comments	0	test	PRIMARY	1	comment_ID	A	0	NULL	NULL		BTREE			NO
	24.	def	test	wp_comments	1	test	comment_post_ID	1	comment_post_ID	A	0	NULL	NULL		BTREE			NO
	25.	def	test	wp_comments	1	test	comment_approved_date_gmt	1	comment_approved	A	0	NULL	NULL		BTREE			NO
	26.	def	test	wp_comments	1	test	comment_approved_date_gmt	2	comment_date_gmt	A	0	NULL	NULL		BTREE			NO
	27.	def	test	wp_comments	1	test	comment_date_gmt	1	comment_date_gmt	A	0	NULL	NULL		BTREE			NO
	28.	def	test	wp_comments	1	test	comment_parent	1	comment_parent	A	0	NULL	NULL		BTREE			NO
	29.	def	test	wp_comments	1	test	comment_author_email	1	comment_author_email	A	0	10	NULL		BTREE			NO
	30.	def	test	wp_term_relationships	0	test	PRIMARY	1	object_id	A	1	NULL	NULL		BTREE			NO