PL 保留和非保留关键字
PL 保留关键字是在 PL 中具有特殊含义的标识符,不可用于存储过程名、函数名、类型名、变量名等。PL 非保留关键字可以作为标识符而不需要加引号。它们不区分大小写。
PL 保留关键字
| 首字母 | 保留关键字 |
|---|---|
| A | ALTER |
| B | BEFORE,BY |
| C | CALL,CASE,CONDITION,CONTINUE,CREATE,CURRENT_USER,CURSOR,COMMIT |
| D | DECLARE,DEFAULT,DELETE,DETERMINISTIC,DROP,DO |
| E | EXISTS,ELSE,ELSIF,EXISTS,EXIT |
| F | FETCH,FOR,FROM |
| I | IF,IN,INDEX,INDEXES, INOUT,INSERT,INTO IS ITERATE |
| L | LEAVE,LIMIT,LONG,LOOP |
| M | MODIFIES |
| N | NOT |
| O | ON,OR,OUT |
| P | PROCEDURE |
| R | READS,REPEAT,REPLACE,RESIGNAL,RETURN |
| S | SELECT,SIGNAL,SQL,SQLEXCEPTION,SQLSTATE,SQLWARNING |
| T | TABLE,THEN,TRIGGER |
| U | UPDATE,USING,UNTIL |
| W | WHEN,WHILE |
PL 非保留关键字
| 首字母 | 保留关键字 |
|---|---|
| A | AFTER,AUTHID |
| B | BEGIN_KEY,BINARY_INTEGER,BODY |
| C | C,CATALOG_NAME CLASS_ORIGIN,CLOSE,COLUMN_NAME,COMMENT,CONSTRAINT_CATALOG,CONSTRAINT_NAME,CONSTRAINT_ORIGIN,CONSTRAINT_SCHEMA,CONTAINS,COUNT,CURSOR_NAME |
| D | DATA ,DEFINER |
| E | END_KEY,EXTEND |
| F | FOUND,FUNCTION |
| H | HANDLER |
| I | INTERFACE,INVOKER |
| J | JSON |
| L | LANGUAGE |
| M | MESSAGE_TEXT,MYSQL_ERRNO |
| N | NEXT,NO |
| O | OF,OPEN |
| P | PACKAGE,PRAGMA |
| R | RECORD,RETURNS,ROW,ROWTYPE |
| S | SCHEMA_NAME,SECURITY,SUBCLASS_ORIGIN |
| T | TABLE_NAME,TYPE |
| V | VALUE |