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/repeat.html
[begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition expression is true. statement_list consists of one or more statements, each ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
It then sleeps until another gtid_executed_compression_period transactions have taken place, then wakes up to perform the compression again, repeating this loop indefinitely. A global transaction identifier (GTID) is a unique identifier created and ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
Usually you should use the default setting of 0, to prevent infinite loops caused by circular replication. This section explains the server options and system variables that apply to replicas and contains the following: Startup Options for Replicas ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL. Tested with Purify (a commercial memory leakage detector) as well as with Valgrind, a GPL ...
https://dev.mysql.com/doc/refman/5.7/en/sql-compound-statements.html
A compound statement is a block that can contain other blocks; declarations for variables, condition handlers, and cursors; and flow control constructs such as loops and conditional tests. END compound statement and other statements that can be used ...
https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
Compound statements can contain declarations, loops, and other control structure statements. By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
The optimizer choices are limited because only such plans enable outer joins to be executed using the nested-loop algorithm. Table expressions in the FROM clause of a query are simplified in many cases. At the parser stage, queries with right outer ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
The following items from that standard are not currently supported: UNDO handlers FOR loops Stored Routine Concurrency Considerations To prevent problems of interaction between sessions, when a client issues a statement, the server uses a snapshot ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html
Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. For example, the following stored procedure has a body made up of ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-get-config.html
However, this should not be done inside a loop (for example, for each row in a result set) because for repeated calls where the assignment is needed only in the first iteration, using IFNULL(...) is expected to be significantly slower than using an ... Given a configuration option name, returns the option value from the sys_config table, or the provided default value (which may be NULL) if the option does not exist in the ...