MySQL Error number: MY-013189; Symbol: ER_SYS_VAR_NOT_FOUND; SQLSTATE: HY000

文档解释

Error number: MY-013189; Symbol: ER_SYS_VAR_NOT_FOUND; SQLSTATE: HY000

Message: Variable name ‘%s’ not found.

Error MY-013189 ( ER_SYS_VAR_NOT_FOUND) is thrown by MySQL when a query is performed which references a system variable that does not exist.

Error Message:

SQLSTATE[HY000]: General error: 13183 Variable ‘%s’ not found.

Explanations:

Error MY-013189 occurs when a variable is referenced that does not exist. This might happen when the variable is misspelled, or not declared.

Common cases:

When a system variable is defined, or someone is trying to change the value of an existing system variable, they might mistype the variable name.

When a system variable is referenced but is not defined, it leads to this error message.

Solution:

To resolve this issue, make sure to use the correct spelling and case of the system variable name in the query. When defining a system variable, make sure that the variable is known in the scope of the session.

Check for typos in the variable name and make sure the variable is actually defined.

你可能感兴趣的