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/fulltext-search-ngram.html
If a comma (“,”) is defined as a stopword, both “a,” and “,b” are excluded from the index because they contain a comma. Given two documents, one containing “ab” and the other containing “abc”, the search term “ab bc” matches ... The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word ...
https://dev.mysql.com/doc/refman/8.0/en/gis-mysql-specific-functions.html
Also, functions such as ST_GeomFromText() that accept WKT geometry collection arguments understand both OpenGIS 'GEOMETRYCOLLECTION EMPTY' standard syntax and MySQL 'GEOMETRYCOLLECTION()' nonstandard syntax. Also, functions such as ST_GeomFromText() ... MySQL provides a set of useful nonstandard functions for creating geometry ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkt-functions.html
For example, both of the following function calls are valid: ST_MPointFromText('MULTIPOINT (1 1, 2 2, 3 3)') ST_MPointFromText('MULTIPOINT ((1 1), (2 2), (3 3))') Functions such as ST_GeomFromText() that accept WKT geometry collection arguments ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
These syntax restrictions apply: GRANT cannot mix granting both privileges and roles in the same statement. It is permitted to assign both privileges and roles to an account, but you must use separate GRANT statements, each with syntax appropriate ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
Or you can use ROLLUP, which provides both levels of analysis with a single query. The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html
In this example, we assume the hosts are both Linux servers and use SCP to copy the files between them: s2/backups> scp my.mbi_2206_1429 s3:/backups Restore the backup. In this example we assume the hosts are both Linux servers and use SCP to copy ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-partition.html
Consider the following points when deciding whether or not to set an unreachable majority timeout: In a symmetric group, for example a group with two or four servers, if both partitions contain an equal number of servers, both groups consider ... By ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
For Group Replication, this includes both transactions that have been committed and applied, which are in the gtid_executed GTID set, and transactions that have been certified but not yet applied, which are in the group_replication_applier channel.
https://dev.mysql.com/doc/refman/8.0/en/handler-scope.html
A stored program may include handlers to be invoked when certain conditions occur within the program. The applicability of each handler depends on its location within the program definition and on the condition or conditions that it handles: A ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
The following statement would not work because it refers to a table both as my_table and as MY_TABLE: mysql> SELECT * FROM my_table WHERE MY_TABLE.col=1; Partition, subpartition, column, index, stored routine, event, and resource group names are not ... In MySQL, databases correspond to directories within the data ...