PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... It can take the following forms: mysql_error_code: ...HANDLER statement specifies a handler that deals with one or more ...
https://dev.mysql.com/doc/refman/8.0/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... CONDITION statement declares a named error condition, associating a name with a condition that needs ...
https://dev.mysql.com/doc/refman/8.0/en/declare-local-variable.html
type [DEFAULT value] This statement declares local variables within stored programs. The variable can be referred to in blocks nested within the declaring block, except those blocks that declare a variable with the same name. For examples of ...To ...
https://dev.mysql.com/doc/refman/8.0/en/declare-cursor.html
DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT statement that retrieves the rows to be traversed by the cursor. Cursor declarations must appear before handler declarations and after ...The number of columns retrieved by the SELECT statement must match the number of output variables specified in the FETCH ...
https://dev.mysql.com/doc/refman/8.0/en/declare.html
The DECLARE statement is used to define various items local to a program: Local variables. Variable and condition declarations must appear before cursor or handler declarations. END compound statement and must be at its start, before any other ...
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
Valid target designators for storing item information can be stored procedure or function parameters, stored program local variables declared with DECLARE, or user-defined variables. Valid condition_number designators can be stored procedure or ...
https://dev.mysql.com/doc/refman/8.0/en/handler-scope.html
The applicability of each handler depends on its location within the program definition and on the condition or conditions that it handles: A handler declared in a BEGIN ... END block is in scope only for the SQL statements following the handler ...
https://dev.mysql.com/doc/refman/8.0/en/signal.html
It can be an SQLSTATE value (a 5-character string literal) or a condition_name that refers to a named condition previously defined with DECLARE ... Valid simple_value_specification designators can be specified using stored procedure or function ...
https://dev.mysql.com/doc/refman/8.0/en/local-variable-scope.html
The variable can be referred to in blocks nested within the declaring block, except those blocks that declare a variable with the same name. INTO statement, contains a reference to a column and a declared local variable with the same name, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
If explicit_defaults_for_timestamp is disabled, the server enables the nonstandard behaviors and handles TIMESTAMP columns as follows: TIMESTAMP columns not explicitly declared with the NULL attribute are automatically declared with the NOT NULL ...