PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
SCI is a high-speed (1 gigabit per second and higher), high-availability protocol used in building scalable multi-processor systems; it requires special hardware and drivers. In the following section, we answer questions that are frequently asked ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
This operation does not perform an implicit UNLOCK TABLES, so an error results if you perform the operation while there is any active LOCK TABLES or use it a second time without first releasing the locks acquired. | tables_option } flush_option: { ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
If the minimum word length is 4, a search for '+word +the*' could return fewer rows than a search for '+word +the', because the second query ignores the too-short search term the. MySQL can perform boolean full-text searches using the IN BOOLEAN ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...
https://dev.mysql.com/doc/refman/8.0/en/function-optimization.html
The second query contains an expression that uses the nondeterministic function RAND(), which is not constant in the query but in fact has a new value for every row of table t. A function is nondeterministic if, given fixed values for its arguments, ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
MySQL supports built-in (native) functions, loadable functions, and stored functions. This section describes how the server recognizes whether the name of a built-in function is used as a function call or as an identifier, and how the server ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
The second uses a WKT representation converted to a Point with ST_GeomFromText(). Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role TO user_or_role [, user_or_role] ... These syntax restrictions apply: GRANT cannot mix granting both privileges and roles ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html
The second method first performs a range scan, and then groups the resulting tuples. The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-bootstrap.html
If it is saved in the option file, upon restart the server automatically bootstraps a second group with the same name. The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, ...