PL reserved and non-reserved keywords
PL reserved keywords are identifiers that have special meanings in PL. They cannot be used as the names of stored procedures, functions, types, variables, and so on. PL non-reserved keywords can be used as identifiers without being enclosed in quotation marks. They are not case-sensitive.
| Initial letter | Reserved keywords |
|---|
| 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 |
| Initial | Non-reserved keywords |
|---|
| 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 |