[Tools]  Datenbank: `mysql`  Tabelle: `db`

         ---               

SELECT * FROM `db`

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

Tabellen der Datenbank `mysql` bearbeiten

Tabelle `db`

Felder der Tabelle `db`

		Field	Type	Size	NULL	Key	Attribute	Default	Extra	Sortierung	Kommentar
	1.	Host	char	60	nein					utf8_bin
	2.	Db	char	64	nein					utf8_bin
	3.	User	char	80	nein					utf8_bin
	4.	Select_priv	enum('N','Y')		nein			N		utf8_general_ci
	5.	Insert_priv	enum('N','Y')		nein			N		utf8_general_ci
	6.	Update_priv	enum('N','Y')		nein			N		utf8_general_ci
	7.	Delete_priv	enum('N','Y')		nein			N		utf8_general_ci
	8.	Create_priv	enum('N','Y')		nein			N		utf8_general_ci
	9.	Drop_priv	enum('N','Y')		nein			N		utf8_general_ci
	10.	Grant_priv	enum('N','Y')		nein			N		utf8_general_ci
	11.	References_priv	enum('N','Y')		nein			N		utf8_general_ci
	12.	Index_priv	enum('N','Y')		nein			N		utf8_general_ci
	13.	Alter_priv	enum('N','Y')		nein			N		utf8_general_ci
	14.	Create_tmp_table_priv	enum('N','Y')		nein			N		utf8_general_ci
	15.	Lock_tables_priv	enum('N','Y')		nein			N		utf8_general_ci
	16.	Create_view_priv	enum('N','Y')		nein			N		utf8_general_ci
	17.	Show_view_priv	enum('N','Y')		nein			N		utf8_general_ci
	18.	Create_routine_priv	enum('N','Y')		nein			N		utf8_general_ci
	19.	Alter_routine_priv	enum('N','Y')		nein			N		utf8_general_ci
	20.	Execute_priv	enum('N','Y')		nein			N		utf8_general_ci
	21.	Event_priv	enum('N','Y')		nein			N		utf8_general_ci
	22.	Trigger_priv	enum('N','Y')		nein			N		utf8_general_ci
	23.	Delete_history_priv	enum('N','Y')		nein			N		utf8_general_ci

Indizes der Tabelle `db`

		Name	Spalten	Größe	Typ	Duplikate erlaubt	Kardinalität	Kommentar
	1.	PRIMARY	Host		BTREE	nein
	2.	PRIMARY	Db		BTREE	nein
	3.	PRIMARY	User		BTREE	nein	0
	4.	User	User		BTREE	ja