Search Results
https://dev.mysql.com/doc/refman/8.4/en/error-log-rule-based-filtering.html
prio The event priority, to indicate an error, warning, or note/information event. Event Type Priority Symbol Numeric Priority Error event ERROR 1 Warning event WARNING 2 Note/information event INFORMATION 3 There is also a message priority of ...
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
Note You can issue event-manipulation statements when event_scheduler is set to DISABLED. Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this thread. When running, the event ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
Note For a multiple-row insert, LAST_INSERT_ID() and mysql_insert_id() actually return the AUTO_INCREMENT key from the first of the inserted rows. To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/8.4/en/explain-extended.html
The Message value in SHOW WARNINGS output displays how the optimizer qualifies table and column names in the SELECT statement, what the SELECT looks like after the application of rewriting and optimization rules, and possibly other notes about the ... The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following ...
https://dev.mysql.com/doc/refman/8.4/en/expressions.html
Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The following grammar rules define expression syntax in MySQL. For additional information about some of the expression terms, see Expression Term Notes. Expression Term ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html
Note The syntax of the CASE operator described here differs slightly from that of the SQL CASE statement described in Section 15.6.5.1, “CASE Statement”, for use inside stored programs. Note There is also an IF statement, which differs from the ...The second syntax returns the result for the first condition that is ...
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. Note FLUSH LOGS, FLUSH BINARY LOGS, FLUSH TABLES WITH READ LOCK (with or without a table list), and FLUSH TABLES tbl_name ... Note The descriptions here that ...| ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-fine-tuning.html
Note Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created using the ngram parser. For MyISAM tables, note the remarks regarding myisamchk in the instructions that follow for rebuilding MyISAM full-text ...You ...
https://dev.mysql.com/doc/refman/8.4/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. For the preceding query, note that the columns named in the MATCH() function (title and body) are the same as ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
Note Direct modification of grant tables using statements such as INSERT, UPDATE, or DELETE is discouraged and done at your own risk. Note Although it is possible to “reset” an expired password by setting it to its current value, it is ... The ...