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/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/alter-procedure.html
ALTER PROCEDURE proc_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...
https://dev.mysql.com/doc/refman/5.7/en/binlog.html
(See Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”.) The 'str' value is a base 64-encoded string the that server decodes to determine the data change indicated by the corresponding event. It is generated by the ...
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html
Values used with REPLICATION_WILD_TABLE and REPLICATION_WILD_IGNORE_TABLE are string expressions, possibly containing (special) wildcard characters, and so must be quoted. Filters set using this statement differ from those set using the server ...
https://dev.mysql.com/doc/refman/5.7/en/channels-naming-conventions.html
Each replication channel has a unique name which is a string with a maximum length of 64 characters and is case-insensitive. This section describes how naming conventions are impacted by replication channels. Because channel names are used in ...
https://dev.mysql.com/doc/refman/5.7/en/charset-national.html
For example, these data type declarations are equivalent: CHAR(10) CHARACTER SET utf8 NATIONAL CHARACTER(10) NCHAR(10) As are these: VARCHAR(10) CHARACTER SET utf8 NATIONAL VARCHAR(10) NVARCHAR(10) NCHAR VARCHAR(10) NATIONAL CHARACTER VARYING(10) ...