PL reserved keywords are identifiers that have special meanings in PL and cannot be used for storage procedure names, function names, type names, variable names, etc. Non-reserved PL keywords can be used as identifiers without quotation marks. They are case-insensitive.
Reserved PL Keywords
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 |
Non-reserved PL keywords
Initial Letter |
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 |