Search Results
https://dev.mysql.com/doc/refman/8.4/en/differences-from-ansi.html
The CAST() function does not support cast to REAL or BIGINT. We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: There are several differences between ...
https://dev.mysql.com/doc/refman/8.4/en/do.html
DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. It cannot be used ...
https://dev.mysql.com/doc/refman/8.4/en/example-maximum-column-group-row.html
Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause, a LEFT JOIN, or a common table expression with a window function. Common table expression with window function: WITH s1 AS ( SELECT article, dealer, ... Task: For each article, find the dealer or dealers with the most expensive ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-general.html
Does MySQL have a NOW() function with fractions of seconds? A.1.7. Does MySQL have a NOW() function with fractions of seconds? Yes, see Section 13.2.6, “Fractional Seconds in Time Values”. Why did MySQL version numbering skip versions 6 and 7 ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
Note It is not possible to issue FLUSH statements within stored functions or triggers. However, you may use FLUSH in stored procedures, so long as these are not called from stored functions or triggers. | tables_option } flush_option: { BINARY LOGS ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
For example, a value of 3 includes all of the functionality of values 1 and 2. To investigate database page corruption, you might dump your tables from the database with SELECT ... Usually, most of the data obtained in this way is intact. Serious ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
After create This occurs when the thread creates a table (including internal temporary tables), at the end of the function that creates the table. The following list describes thread State values that are associated with general query processing ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-cloning.html
If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members and joining members beforehand to support this function. If you do not want to use this function in a group, do not set it up, in ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-compatibility-upgrade.html
During an online upgrade procedure, if the group is in single-primary mode, all the servers that are not currently offline for upgrading function as they did before. After the primary has been upgraded, you can use the ...The group elects a new ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
You can use the group_replication_switch_to_single_primary_mode() and group_replication_switch_to_multi_primary_mode() functions to move a group from one mode to another while Group Replication is still running. These functions manage the process of ... Group Replication operates either in single-primary mode or in multi-primary ...