148.216.95.41 / mysql wampserver / mysql / db

Table: db"Database privileges"

#	Name	Type	Collation	Null	Default	Action
1	Host	char(60)	utf8_bin	No		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
2	Db	char(64)	utf8_bin	No		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
3	User	char(16)	utf8_bin	No		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
4	Select_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
5	Insert_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
6	Update_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
7	Delete_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
8	Create_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
9	Drop_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
10	Grant_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
11	References_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
12	Index_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
13	Alter_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
14	Create_tmp_table_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
15	Lock_tables_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
16	Create_view_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
17	Show_view_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
18	Create_routine_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
19	Alter_routine_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
20	Execute_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
21	Event_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
22	Trigger_priv	enum('N', 'Y')	utf8_general_ci	No	N	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values

Check AllWith selected:

Print view

Propose table structure

Move columns

Action	Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
Edit	Drop	PRIMARY	BTREE	Yes	No	Host		A	No
Db		A	No
User	2	A	No
Edit	Drop	User	BTREE	No	No	User	1	A	No

Information

Space usage
Data	880	B
Index	5	KiB
Total	5.9	KiB

Row statistics
Format	static
Collation	utf8_bin
Rows	2
Row length	440 B
Row size	3,000 B
Creation	Mar 14, 2014 at 01:30 PM
Last update	May 01, 2014 at 09:06 AM
Last check	Mar 14, 2014 at 01:30 PM