PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-plugins.html
row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row *************************** Name: CSV Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
Not all storage engines update this time, in which case, the value is always NULL. For views, all columns displayed by SHOW TABLE STATUS are NULL except that Name indicates the view name and Comment says VIEW. SHOW TABLE STATUS [{FROM | IN} ...
https://dev.mysql.com/doc/refman/5.7/en/using-spatial-indexes.html
The following query finds all objects that are in the given rectangle: mysql> SET @poly = -> 'Polygon((30000 15000, 31000 15000, 31000 16000, 30000 16000, 30000 15000))'; mysql> SELECT fid,ST_AsText(g) FROM geom WHERE -> ... The optimizer ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html
The value cannot be the error value (that is, 0 or the empty string). A SET value must be the empty string or a value consisting only of the values listed in the column definition separated by commas. For SET, the value is inserted as given except ... ENUM and SET columns provide an efficient way to define columns that can contain only a given set of ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
To name an account for firewall operations, specify it as a single quoted string ('user_name@host_name'). The requirement for naming accounts as a single quoted string for firewall operations means that you cannot use accounts that have embedded @ ... Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 6.4.6.2, “Installing or Uninstalling MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
Suppose that my_auth_plugin returns a user name of employee to the server, based on the content of 'my_auth_string' and perhaps by consulting some external authentication system. If present, the string provides information that helps the plugin ...
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 ...