MySQL Tutorial/Data Dictionary/db

Материал из SQL эксперт
Версия от 09:53, 26 мая 2010; Admin (обсуждение | вклад) (1 версия)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

db table structure

mysql>
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)