PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
You may not use stored functions or loadable functions in such expressions, nor may you use any table references; however, you may use SELECT FROM DUAL. Note Statements such as SELECT or SHOW that merely return a result set have no effect when used ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-security.html
MySQL connectors and clients select the highest TLS version available by default. Where can I find documentation that addresses security issues for MySQL? A.9.2. Is SSL support built into MySQL binaries, or must I recompile the binary myself to ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
For a database named dbname, use this query on the INFORMATION_SCHEMA.ROUTINES table: SELECT ROUTINE_TYPE, ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA='dbname'; For more information, see Section 28.3.30, “The ...Where can I ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
Some examples of such queries are shown here: # MATCH() in SELECT list... SELECT MATCH (a) AGAINST ('abc') FROM t GROUP BY a WITH ROLLUP; SELECT 1 FROM t GROUP BY a, MATCH (a) AGAINST ('abc') WITH ROLLUP; # ...in HAVING clause... SELECT 1 FROM t ...
https://dev.mysql.com/doc/refman/8.0/en/gis-general-property-functions.html
mysql> SELECT ST_Dimension(ST_GeomFromText('LineString(1 1,2 2)')); +------------------------------------------------------+ | ST_Dimension(ST_GeomFromText('LineString(1 1,2 2)')) | +------------------------------------------------------+ | 1 | ...
https://dev.mysql.com/doc/refman/8.0/en/gis-polygon-property-functions.html
mysql> SET @poly = ST_GeomFromText('POLYGON((0 0,10 0,10 10,0 10,0 0),(5 5,7 5,7 7,5 7,5 5))'); mysql> SELECT ST_GeometryType(@poly),ST_AsText(ST_Centroid(@poly)); +------------------------+--------------------------------------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-changing-group-mode.html
Changing to Single-Primary Mode Use the group_replication_switch_to_single_primary_mode() function to change a group running in multi-primary mode to single-primary mode by issuing: SELECT group_replication_switch_to_single_primary_mode() When you ... This section explains how to change the mode which a group is running in, either single or ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-fault.html
The donor for distributed recovery is selected randomly from the existing list of suitable online group members in the current view. Selecting a random donor means that there is a good chance that the same server is not selected more than once when ... Group Replication's distributed recovery process has a number of built-in measures to ensure fault tolerance in the event of any problems during the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-network-partitioning.html
mysql> SELECT @@group_replication_local_address; Once you know the group communication addresses of s1 (127.0.0.1:10000) and s2 (127.0.0.1:10001), you can use that on one of the two servers to inject a new membership configuration, thus overriding ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.0/en/handler.html
There are several reasons to use the HANDLER interface instead of normal SELECT statements: HANDLER is faster than SELECT: A designated storage engine handler object is allocated for the HANDLER ... The handler interface does not have to provide a ... HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ...