Properties

Engine: MyISAM 
Row format:
Rows: Fixed 
Avg row length:
Data length:
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