Search Results
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier. With this modifier, certain characters have special meaning at the beginning or end of words in the search string. In the following query, the + and - operators ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
If you create a MyISAM table and insert only one or two rows of text into it, every word in the text occurs in at least 50% of the rows. By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-mecab.html
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 delimiters. To address this limitation ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-ngram.html
The following example demonstrates creating a table with an ngram FULLTEXT index, inserting sample data (Simplified Chinese text), and viewing tokenized data in the Information Schema INNODB_FT_INDEX_CACHE table. The built-in MySQL full-text parser ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
end This occurs at the end but before the cleanup of ALTER TABLE, CREATE VIEW, DELETE, INSERT, SELECT, or UPDATE statements. init This occurs before the initialization of ALTER TABLE, DELETE, INSERT, SELECT, or UPDATE statements. The following list ...
https://dev.mysql.com/doc/refman/8.4/en/gis-mysql-specific-functions.html
For example, you can insert the geometry return value from Point() directly into a POINT column: INSERT INTO t1 (pt_col) VALUES(Point(1,2)); GeomCollection(g [, g] ...) Constructs a GeomCollection value from the geometry arguments. MySQL provides a ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. Also, the data was inserted into the table and ... The process of starting a group for the first time is called ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
No read skew on read/write transactions, such as this one: > BEGIN; > SELECT x FROM t1; -- x=1 because x=2 is in the backlog; > INSERT x INTO t2; > COMMIT; This query should not cause a conflict but writes outdated values. Although the Transaction ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
(This may occur for bulk inserts or deletes, or some ALTER TABLE statements, for example.) If this happens, the statistics are collected using whatever value innodb_stats_method or myisam_stats_method has at the time. Storage engines collect ...