Properties

Engine:	MyISAM
Row format:	9
Rows:	Fixed
Avg row length:	0
Data length:	0
Max data length:	866
Index length:	1859720839167
Data free:	4096
Auto increment:	866
Create time:
Update time:	2006/19/07/2006
Check time:	2006/18/11/2006
Create_options:
Comment:	utf8_bin

Columns

		Name	Data Type	NULL	Default
		Host	char(60)		PRI
		Db	char(64)		PRI
		User	char(16)		PRI
		Select_priv	enum('N', 'Y')
		Insert_priv	enum('N', 'Y')
		Update_priv	enum('N', 'Y')
		Delete_priv	enum('N', 'Y')
		Create_priv	enum('N', 'Y')
		Drop_priv	enum('N', 'Y')
		Grant_priv	enum('N', 'Y')
		References_priv	enum('N', 'Y')
		Index_priv	enum('N', 'Y')
		Alter_priv	enum('N', 'Y')
		Create_tmp_table_priv	enum('N', 'Y')
		Lock_tables_priv	enum('N', 'Y')

Total: 15 column(s)

Indexes

	Name	Primary	Unique
	PRIMARY
	User

Total: 2 indexes(s)

SQL

CREATE TABLE `db` (
  `Host` char(60) collate utf8_bin NOT NULL default '',
  `Db` char(64) collate utf8_bin NOT NULL default '',
  `User` char(16) collate utf8_bin NOT NULL default '',
  `Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `References_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  `Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N',
  PRIMARY KEY  (`Host`,`Db`,`User`),
  KEY `User` (`User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges'

See Also

List of tables