Search Results
https://dev.mysql.com/doc/refman/8.4/en/fractional-seconds.html
MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-query-expansion.html
Blind query expansion (also known as automatic relevance feedback) is enabled by adding WITH QUERY EXPANSION or IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION following the search phrase. The following example shows this difference: mysql> SELECT * ... Full-text search supports query expansion (and in particular, its variant “blind query ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-ngram.html
ngram Parser Term Search For natural language mode search, the search term is converted to a union of ngram terms. For boolean mode search, the search term is converted to an ngram phrase search. The built-in MySQL full-text parser uses the white ...
https://dev.mysql.com/doc/refman/8.4/en/functions.html
To tell the MySQL server to accept spaces after function names by starting it with the --sql-mode=IGNORE_SPACE option. (See Section 7.1.11, “Server SQL Modes”.) Individual client programs can request this behavior by using the ... Expressions ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
If that mode is enabled, the server rejects the query as illegal because country is not listed in the GROUP BY clause. The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
For a group in single-primary mode, the primary might have transactions that are not yet present on other members at the time of the network partition. Warning For a group in single-primary mode, the primary might have transactions that are not yet ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-summary.html
For example, in multi-primary mode, a local transaction might be externalized immediately following certification, although a remote transaction that is earlier in the global order has not yet been applied. In single-primary mode, on the primary ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication.html
Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. Alternatively, groups can be deployed in multi-primary mode, where all servers can accept updates, even if they are issued ... This chapter explains Group Replication in MySQL 8.4, and how to install, configure and monitor ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-parameters-table.html
The PARAMETER_NAME and PARAMETER_MODE values are NULL because the return value has no name and the mode does not apply. The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
SQL_MODE The SQL mode in effect when the routine was created or altered, and under which the routine executes. The ROUTINES table provides information about stored routines (stored procedures and stored functions). The ROUTINES table does not ...