MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 11 to 20 of 32 total results

https://dev.mysql.com/doc/refman/5.7/en/signal.html

SIGNAL Overview Signal Condition Information Items Effect of Signals on Handlers, Cursors, and Statements SIGNAL Overview The condition_value in a SIGNAL statement indicates the error value to be returned. Some signal values cause statement ...

13.5 Prepared Statements

https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html

However, a cursor cannot be used for a dynamic statement that is prepared and executed with PREPARE and EXECUTE. The statement for a cursor is checked at cursor creation time, so the statement cannot be dynamic. Using prepared statements with ...

13.6.7.2 DECLARE ... HANDLER Statement

https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html

This is relevant within the context of cursors and is used to control what happens when a cursor reaches the end of a data set. DECLARE CONTINUE HANDLER FOR NOT FOUND BEGIN -- body of handler END; For another example, see Section 13.6.6, ...

14.6.2.3 Sorted Index Builds

https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html

This method involved opening a B-tree cursor to find the insert position and then inserting entries into a B-tree page using an optimistic insert. If an insert failed due to a page being full, a pessimistic insert would be performed, which involves ... InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding ...

2.3.4.8 Starting MySQL as a Windows Service

https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html

Place your cursor at the end of the text appearing in the space marked Variable Value. On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and stops. A ...

23.8 Restrictions on Stored Programs

https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html

Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions. There are also some restrictions specific to stored functions but not to stored procedures. The restrictions for stored ...

13.6.4 Variables in Stored Programs

https://dev.mysql.com/doc/refman/5.7/en/stored-program-variables.html

INTO var_list or by opening a cursor and using FETCH ... System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program context. In addition, stored programs can use DECLARE to define ...

2.3.4.7 Customizing the PATH for MySQL Tools

https://dev.mysql.com/doc/refman/5.7/en/mysql-installation-windows-path.html

Place your cursor at the end of the text appearing in the space marked Variable Value. Warning You must exercise great care when editing your system PATH by hand; accidental deletion or modification of any portion of the existing PATH value can ...

13.6.4.2 Local Variable Scope and Resolution

https://dev.mysql.com/doc/refman/5.7/en/local-variable-scope.html

Similarly, the cursor definition in the following procedure contains a SELECT statement that refers to xname. The scope of a local variable is the BEGIN ... The variable can be referred to in blocks nested within the declaring block, except those ...

B.1 Error Message Sources and Elements

https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html

Class = '02' indicates “not found.” This is relevant within the context of cursors and is used to control what happens when a cursor reaches the end of a data set. This section discusses how error messages originate within MySQL and the ...

Displaying 11 to 20 of 32 total results