PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/cursor-restrictions.html
Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A server-side cursor enables a result set to be generated on the server side, but not transferred to the client except for those rows that the client ...For ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/5.7/en/close.html
If not closed explicitly, a cursor is closed at the end of the BEGIN ...
https://dev.mysql.com/doc/refman/5.7/en/fetch.html
This statement fetches the next row for the SELECT statement associated with the specified cursor (which must be open), and advances the cursor pointer. If a row exists, the fetched columns are stored in the named variables. The number of columns ...
https://dev.mysql.com/doc/refman/5.7/en/open.html
OPEN cursor_name This statement opens a previously declared cursor. For an example, see Section 13.6.6, “Cursors”. ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
cursor An internal MySQL data structure that represents the result set of an SQL statement. Although SQL usually handles the processing of cursors for you, you might delve into the inner workings when dealing with performance-critical code. dynamic ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
Can I pass a cursor as an IN parameter to a stored procedure? A.4.19. Can I return a cursor as an OUT parameter from a stored procedure? A.4.20. Can I pass a cursor as an IN parameter to a stored procedure? Cursors are only available inside stored ...Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
Backspace deletes the character before the cursor and typing new characters enters them at the cursor position. For example, in libedit, Control+W deletes everything before the current cursor position and Control+U deletes the entire line. In ...
https://dev.mysql.com/doc/refman/5.7/en/declare.html
Variable and condition declarations must appear before cursor or handler declarations. The DECLARE statement is used to define various items local to a program: Local variables. END compound statement and must be at its start, before any other ...