PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
Additionally, for BTREE indexes, comparison of a key part with a constant value is a range condition when using the >, <, >=, <=, BETWEEN, !=, or <> operators, or LIKE comparisons if the argument to LIKE is a constant string that does not start with ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
The value of the gtid_purged system variable is set to an empty string (''), the global value (but not the session value) of the gtid_executed system variable is set to an empty string, and the mysql.gtid_executed table is cleared (see ... RESET ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
An error number of 0 and message of the empty string mean “no error.” If the Last_IO_Error value is not empty, the error values also appear in the replica's error log. An error number of 0 and message of the empty string mean “no error.” If ... SHOW SLAVE STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/5.7/en/sys-execute-prepared-stmt.html
Given an SQL statement as a string, executes it as a prepared statement. Parameters in_query LONGTEXT CHARACTER SET utf8: The statement string to execute. The prepared statement is deallocated after execution, so it is not subject to reuse. Thus, ...
https://dev.mysql.com/doc/refman/5.7/en/working-with-null.html
A common error when working with NULL is to assume that it is not possible to insert a zero or an empty string into a column defined as NOT NULL, but this is not the case. The NULL value can be surprising until you get used to it. Conceptually, ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-aws-plugin.html
The plugin library file contains the keyring_aws plugin and two loadable functions, keyring_aws_rotate_cmk() and keyring_aws_rotate_keys(). Start the MySQL server and install the functions associated with the keyring_aws plugin. This is a one-time ... Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/dbug-package.html
The effect of this default is: d: Enable output for all debug macros t: Trace function calls and exits i: Add PID to output lines o,/tmp/mysqld.trace, O,\mysqld.trace: Set the debug output file. Here are some example debug control strings as they ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
A stored routine is either a procedure or a function. Stored routines are created with the CREATE PROCEDURE and CREATE FUNCTION statements (see Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”). A function can be called from ...A procedure is invoked using a CALL statement (see Section 13.2.1, “CALL Statement”), and can only pass back values using output ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
If the group is operating in multi-primary mode, shows an empty string. Handler_external_lock The server increments this variable for each call to its external_lock() function, which generally occurs at the beginning and end of access to a table ...
https://dev.mysql.com/doc/refman/5.7/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 ...