Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
The following list describes the permitted predefined functions for function items: audit_log_exclude_accounts_is_null() Checks whether the audit_log_exclude_accounts system variable is NULL. For information about using JSON data in MySQL, see ...
https://dev.mysql.com/doc/refman/8.4/en/charset-connection.html
To tell the server to perform no conversion of result sets or error messages, set character_set_results to NULL or binary: SET character_set_results = NULL; SET character_set_results = binary; For more information about character sets and error ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-foreign-key.html
The available referential actions are RESTRICT, CASCADE, SET NULL, and NO ACTION (the default). Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL supports ...
https://dev.mysql.com/doc/refman/8.4/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. The CSV storage engine is always compiled into the MySQL server. To examine the source for the CSV engine, look in the storage/csv directory of a MySQL source ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-types.html
MySQL permits you to store a “zero” value of '0000-00-00' as a “dummy date.” In some cases, this is more convenient than using NULL values, and uses less data and index space. “Zero” date or time values used through Connector/ODBC are ...
https://dev.mysql.com/doc/refman/8.4/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. 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.
https://dev.mysql.com/doc/refman/8.4/en/firewall-usage.html
To clear the training account if it actually is desired to enable all group members to perform training in RECORDING mode, call sp_set_firewall_group_mode_and_user() and pass a NULL value for the account argument: CALL ... Before using MySQL ...
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/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 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, ...