Mega Code Archive

 

Categories / MySQL Tutorial / Data Dictionary

 

Db table structure

mysql> mysql> desc mysql.db; +-----------------------+---------------+------+-----+---------+-------+ | Field                 | Type          | Null | Key | Default | Extra | +-----------------------+---------------+------+-----+---------+-------+ | Host                  | char(60)      | NO   | PRI |         |       | | Db                    | char(64)      | NO   | PRI |         |       | | User                  | char(16)      | NO   | PRI |         |       | | Select_priv           | enum('N','Y') | NO   |     | N       |       | | Insert_priv           | enum('N','Y') | NO   |     | N       |       | | Update_priv           | enum('N','Y') | NO   |     | N       |       | | Delete_priv           | enum('N','Y') | NO   |     | N       |       | | Create_priv           | enum('N','Y') | NO   |     | N       |       | | Drop_priv             | enum('N','Y') | NO   |     | N       |       | | Grant_priv            | enum('N','Y') | NO   |     | N       |       | | References_priv       | enum('N','Y') | NO   |     | N       |       | | Index_priv            | enum('N','Y') | NO   |     | N       |       | | Alter_priv            | enum('N','Y') | NO   |     | N       |       | | Create_tmp_table_priv | enum('N','Y') | NO   |     | N       |       | | Lock_tables_priv      | enum('N','Y') | NO   |     | N       |       | | Create_view_priv      | enum('N','Y') | NO   |     | N       |       | | Show_view_priv        | enum('N','Y') | NO   |     | N       |       | | Create_routine_priv   | enum('N','Y') | NO   |     | N       |       | | Alter_routine_priv    | enum('N','Y') | NO   |     | N       |       | | Execute_priv          | enum('N','Y') | NO   |     | N       |       | +-----------------------+---------------+------+-----+---------+-------+ 20 rows in set (0.01 sec)