MyISAM |
9 |
Fixed |
0 |
0 |
0 |
3478923509759 |
1024 |
0 |
|
2006/19/07/2006 |
2006/19/07/2006 |
|
utf8_bin |
|
|
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)
Total: 1 indexes(s)
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'
List of tables