刚开始接触一塌糊涂数据库的内容: 进入查询到数据库里各表如下:
但是表里的各列具体意思不是很清楚,急切盼望有人帮忙解释一下!非常感谢!
在线等待中......
2 use mysql;
show tables;
显示数据库中的表
+---------------+
|Tables_in_mysql|
+---------------+
| columns_priv |
| db |
| func |
| tables_priv |
| user |
+---------------+
3 desribe+表名
显示数据库中数据表的结构
desribe db;
+------------------------------------------------------------------------+
|Field |Type |Null |key |Defult |Extra |
+------------------------------------------------------------------------+
|Host |char(60)binary | |PRI | | |
|------------------------------------------------------------------------+
| Db |char(64)binary | |PRI | | |
-------------------------------------------------------------------------+
| user |char(16)binary | |PRI | | |
-------------------------------------------------------------------------+
| Select_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Insert_priv |enum('N','Y') | | | N | |
+------------------------------------------------------------------------+
| Update_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Delete_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Creat_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Drop_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Grant_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| References_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Index_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Alter_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
desribe column_priv;
+------------------------------------------------------------------------+
|Field |Type |Null |key |Defult |Extra |
+------------------------------------------------------------------------+
|Host |char(60)binary | |PRI | | |
|------------------------------------------------------------------------+
| Db |char(64)binary | |PRI | | |
-------------------------------------------------------------------------+
| user |char(16)binary | |PRI | | |
-------------------------------------------------------------------------+
| Table_name |char(64)binary | |PRI | | |
-------------------------------------------------------------------------+
| column_name |char(64)binary | |PRI | | |
+------------------------------------------------------------------------+
| Timestamp | Timestamp(14) | YES | | |NULL |
-------------------------------------------------------------------------+
| column_priv |set('Select','Insert', | | | |
| 'Update','References') | | | |
-------------------------------------------------------------------------+
desribe func;
+------------------------------------------------------------------------+
|Field |Type |Null |key |Defult |Extra |
+------------------------------------------------------------------------+
|name |char(64)binary | |PRI | | |
|------------------------------------------------------------------------+
|ret |tinyint(1) | | | | NULL |
-------------------------------------------------------------------------+
|dl |char(128) | | | | |
-------------------------------------------------------------------------+
| Type |enum('function','aggregate')| | | function|
-------------------------------------------------------------------------+
desribe host;
+------------------------------------------------------------------------+
|Field |Type |Null |key |Defult |Extra |
+------------------------------------------------------------------------+
|Host |char(60)binary | |PRI | | |
|------------------------------------------------------------------------+
| Db |char(64)binary | |PRI | | |
-------------------------------------------------------------------------+
| Select_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Insert_priv |enum('N','Y') | | | N | |
+------------------------------------------------------------------------+
| Update_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Delete_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Creat_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Drop_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Grant_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| References_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Index_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Alter_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
desribe tables_priv;
+------------------------------------------------------------------------+
|Field |Type |Null |key |Defult |Extra |
+------------------------------------------------------------------------+
|Host |char(60)binary | |PRI | | |
|------------------------------------------------------------------------+
| Db |char(64)binary | |PRI | | |
-------------------------------------------------------------------------+
| user |char(16)binary | |PRI | | |
-------------------------------------------------------------------------+
| Table_name |char(64)binary | |PRI | | |
-------------------------------------------------------------------------+
| Grantor |char(11)binary | |MUL | | |
+------------------------------------------------------------------------+
| Timestamp | Timestamp(14) | YES | | |NULL |
-------------------------------------------------------------------------+
| Table_priv |set('Select','Insert', | | | |
| 'Update','Delete','Create','Drop','Grant','References','I| ndex','Alter') |
-------------------------------------------------------------------------+
| column_priv | | | | | |
-------------------------------------------------------------------------+
desribe user;
+------------------------------------------------------------------------+
|Field |Type |Null |key |Defult |Extra |
+------------------------------------------------------------------------+
|Host |char(60)binary | |PRI | | |
|------------------------------------------------------------------------+
|User |char(16)binary | |PRI | | |
-------------------------------------------------------------------------+
|Password |char(16)binary | | | | |
-------------------------------------------------------------------------+
| Select_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Insert_priv |enum('N','Y') | | | N | |
+------------------------------------------------------------------------+
| Update_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Delete_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Creat_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Drop_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Grant_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| References_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Index_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
| Alter_priv |enum('N','Y') | | | N | |
-------------------------------------------------------------------------+
--
FROM 202.118.1.100