Search Results
https://dev.mysql.com/doc/refman/8.4/en/debugging-server.html
If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which disables all new, potentially unsafe functionality). If mysqld does not want to start, verify that you have no my.cnf files ...
https://dev.mysql.com/doc/refman/8.4/en/declare-cursor.html
DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT statement that retrieves the rows to be traversed by the cursor. The number of columns retrieved by the SELECT statement must match the ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a ...
https://dev.mysql.com/doc/refman/8.4/en/distinct-optimization.html
DISTINCT combined with ORDER BY needs a temporary table in many cases. Because DISTINCT may use GROUP BY, learn how MySQL works with columns in ORDER BY or HAVING clauses that are not part of the selected columns. In most cases, a DISTINCT clause ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-format.html
Each error log sink (writer) component has a characteristic output format it uses to write messages to its destination, but other factors may influence the content of the messages: The information available to the log sink. If a log filter ...
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
MySQL Events are tasks that run according to a schedule. When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-general.html
Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? A.1.3. Does MySQL have a NOW() function with fractions of seconds? A.1.7. Which version of MySQL is production-ready (GA)? MySQL 9.5, 8.4, and 8.0 are actively supported ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. A collection is a set of one or more columns included in a FULLTEXT index. For each row in the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. This is why the value of the group_replication_bootstrap_group option was ...