PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
It makes SQL operations faster, by enabling better use of indexes and eliminating overhead for testing whether each value is NULL. If you really need NULL values in your tables, use them. Just avoid the default setting that allows NULL values in ...
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/declare-handler.html
SQLSTATE [VALUE] sqlstate_value: A 5-character string literal indicating an SQLSTATE value, such as '42S01' to specify “unknown table”: DECLARE CONTINUE HANDLER FOR SQLSTATE '42S02' BEGIN -- body of handler END; Do not use SQLSTATE values that ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html
The boolean variables including MYSQL_RANDOM_ROOT_PASSWORD, MYSQL_ONETIME_PASSWORD, MYSQL_ALLOW_EMPTY_PASSWORD, and MYSQL_LOG_CONSOLE are made true by setting them with any strings of nonzero lengths. A MySQL Docker installation is different from a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
This section provides examples of stored functions (see Chapter 23, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterstatus.html
In that case, the values that you need to use later when specifying the source's log file and position are the empty string ('') and 4. To configure the replica to start the replication process at the correct point, you need to note the source's ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
This section explains these concepts and is essential reading before attempting to modify the replication mode of an online server. This means that fields which display GTID sets, such as gtid_executed, gtid_purged, RECEIVED_TRANSACTION_SET in the ... To be able to safely configure the replication mode of an online server it is important to understand some key concepts of ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
All credentials are stored in the authentication_string column, including those formerly stored in the Password column. If performing an in-place upgrade to MySQL 5.7.6 or later, run mysql_upgrade as directed by the in-place upgrade procedure to ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
The password and user name values are compared as binary strings on a byte-by-byte basis. Assuming that is true, each substring of the password of length 4 up to 100 is compared to the words in the dictionary file. This section describes the ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
If a query includes GROUP BY but you want to avoid the overhead of sorting the result, you can suppress sorting by specifying ORDER BY NULL. For example: INSERT INTO foo SELECT a, COUNT(*) FROM bar GROUP BY a ORDER BY NULL; The optimizer may still ... This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER ...