help_category

• 该表提供查询帮助类别信息
• 表结构定义

CREATE TABLE `help_category` (
  `help_category_id` smallint(5) unsigned NOT NULL,
  `name` char(64) NOT NULL,
  `parent_category_id` smallint(5) unsigned DEFAULT NULL,
  `url` text NOT NULL,
  PRIMARY KEY (`help_category_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='help categories';

• 表字段含义

• help_category_id：帮助类别名称在表中的记录ID
• name：帮助类别名称
• parent_category_id：父类别名称在表中的记录ID，一些类别具有子类别，例如：绝大多数的类别其实是Contents类别的子类别（且是顶层类别，也是一级父类别），还有一部分是Geographic Features 类别的子类别（二级父类别），一部分是Functions的子类别（二级父类别）
• url ：对应在MySQL 官方手册中的链接地址

• 表记录内容示例

root@localhost : mysql 01:10:59> select * from help_category;
+------------------+-----------------------------------------------+--------------------+-----+
| help_category_id | name                                          | parent_category_id | url |
+------------------+-----------------------------------------------+--------------------+-----+
|                1 | Geographic                                    |                  0 |     |
|                2 | Polygon properties                            |                 35 |     |
|                3 | Numeric Functions                             |                 39 |     |
|                4 | WKT                                           |                 35 |     |
|                5 | Plugins                                       |                 36 |     |
|                6 | Control flow functions                        |                 39 |     |
|                7 | MBR                                           |                 35 |     |
|                8 | Transactions                                  |                 36 |     |
|                9 | Help Metadata                                 |                 36 |     |
|               10 | Account Management                            |                 36 |     |
|               11 | Point properties                              |                 35 |     |
|               12 | Encryption Functions                          |                 39 |     |
|               13 | LineString properties                         |                 35 |     |
|               14 | Miscellaneous Functions                       |                 39 |     |
|               15 | Logical operators                             |                 39 |     |
|               16 | Functions and Modifiers for Use with GROUP BY |                 36 |     |
|               17 | Information Functions                         |                 39 |     |
|               18 | Storage Engines                               |                 36 |     |
|               19 | Bit Functions                                 |                 39 |     |
|               20 | Comparison operators                          |                 39 |     |
|               21 | Table Maintenance                             |                 36 |     |
|               22 | User-Defined Functions                        |                 36 |     |
|               23 | Data Types                                    |                 36 |     |
|               24 | Compound Statements                           |                 36 |     |
|               25 | Geometry constructors                         |                 35 |     |
|               26 | GeometryCollection properties                 |                  1 |     |
|               27 | Administration                                |                 36 |     |
|               28 | Data Manipulation                             |                 36 |     |
|               29 | Utility                                       |                 36 |     |
|               30 | Language Structure                            |                 36 |     |
|               31 | Geometry relations                            |                 35 |     |
|               32 | Date and Time Functions                       |                 39 |     |
|               33 | WKB                                           |                 35 |     |
|               34 | Procedures                                    |                 36 |     |
|               35 | Geographic Features                           |                 36 |     |
|               36 | Contents                                      |                  0 |     |
|               37 | Geometry properties                           |                 35 |     |
|               38 | String Functions                              |                 39 |     |
|               39 | Functions                                     |                 36 |     |
|               40 | Data Definition                               |                 36 |     |
+------------------+-----------------------------------------------+--------------------+-----+
40 rows in set (0.00 sec)

---

上一篇：帮助信息表 |下一篇：help_keyword表