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/mysql-commands.html
If you provide an argument to the help command, mysql uses it as a search string to access server-side help from the contents of the MySQL Reference Manual. delimiter str, \d str Change the string that mysql interprets as the separator between SQL ... mysql sends each SQL statement that you issue to the server to be ...
https://dev.mysql.com/doc/refman/5.7/en/windows-pluggable-authentication.html
Authentication string syntax for the Windows authentication plugin follows these rules: The string consists of one or more user mappings separated by commas. Thus, these statements are equivalent: CREATE USER sql_admin IDENTIFIED WITH ... Note ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
However, quotation marks are necessary to specify a user_name string containing special characters (such as -), or a host_name string containing special characters or wildcard characters such as % (for example, 'test-user'@'%.com'). Quote user names ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT OPTION | resource_option} ...] GRANT PROXY ON user TO user [, user] ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
} export_options: [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] SELECT is used to retrieve rows selected from one or more tables, and can ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
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 ...