Mega Code Archive

 
Categories / MySQL Tutorial / Data Dictionary
 

Host

mysql> desc host; +-----------------------+---------------+------+-----+---------+-------+ | Field                 | Type          | Null | Key | Default | Extra | +-----------------------+---------------+------+-----+---------+-------+ | Host                  | char(60)      | NO   | PRI |         |       | | Db                    | char(64)      | 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       |       | +-----------------------+---------------+------+-----+---------+-------+ 19 rows in set (0.02 sec) mysql> use mysql Database changed