PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/example-storage-engine.html
The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from ...
https://dev.mysql.com/doc/refman/9.7/en/examples.html
Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/9.7/en/extensions-to-ansi.html
The KEY_BLOCK_SIZE clause in the following comment is executed only by servers from MySQL 5.1.10 or higher: CREATE TABLE t1(a INT, KEY (a)) /*!50110 KEY_BLOCK_SIZE=1024 */; The following descriptions list MySQL extensions, organized by category. If ... MySQL Server supports some extensions that you are not likely to find in other SQL ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-boolean.html
The full-text engine splits the phrase into words and performs a search in the FULLTEXT index for the words. '+apple macintosh' Find rows that contain the word “apple”, but rank rows higher if they also contain “macintosh”. '+apple ... MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-natural-language.html
Note The term “document” may be used interchangeably with the term “row”, and both terms refer to the indexed part of the row. The full-text engine splits the phrase into words and performs a search in the FULLTEXT index for the words. If ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...
https://dev.mysql.com/doc/refman/9.7/en/function-optimization.html
This UPDATE statement uses a nondeterministic function to select rows to be modified: UPDATE t SET col_a = some_expr WHERE id = FLOOR(1 + RAND() * 49); Presumably the intent is to update at most a single row for which the primary key matches the ...
https://dev.mysql.com/doc/refman/9.7/en/grant.html
Issuing multiple GRANT statements containing wildcards may not have the expected effect on DML statements; when resolving grants involving wildcards, MySQL takes only the first matching grant into consideration. Enabling partial_revokes causes MySQL ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-functions-for-maximum-consensus.html
Default value is 10, valid values are integers in the range of 10 to 200. The following functions enable you to inspect and configure the maximum number of consensus instances that a group can execute in parallel.
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...