Properties

Engine: MyISAM 
Row format:
Rows: Fixed 
Avg row length:
Data length:
Max data length:
Index length: 3478923509759 
Data free: 1024 
Auto increment:
Create time:  
Update time: 2006/19/07/2006 
Check time: 2006/19/07/2006 
Create_options:  
Comment: utf8_bin 

Columns

Name Data Type NULL Default
    Host  char(60)    PRI 
    Db  char(64)    PRI 
    User  char(16)    PRI 
    Table_name  char(64)    PRI 
    Column_name  char(64)    PRI 
    Timestamp  timestamp     
    Column_priv  set('Select', 'Insert', 'Update', 'Referenc     
Total: 7 column(s)

Indexes

Name Primary Unique
  PRIMARY     
Total: 1 indexes(s)

SQL

CREATE TABLE `columns_priv` (
  `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 '',
  `Table_name` char(64) collate utf8_bin NOT NULL default '',
  `Column_name` char(64) collate utf8_bin NOT NULL default '',
  `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Column_priv` set('Select','Insert','Update','References') character set utf8 NOT NULL default '',
  PRIMARY KEY  (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges'

See Also

List of tables