Search Results
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-literals.html
The value inserted must not have a zero for the month part, the day part, or both parts. Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
Partitioned Table Support DELETE supports explicit partition selection using the PARTITION clause, which takes a list of the comma-separated names of one or more partitions or subpartitions (or both) from which to select rows to be dropped. Given a ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html
Both HKDF and PBKDF2 can use salts, and their use is recommended to help prevent attacks based on dictionaries of common passwords or rainbow tables. If you want to store these results, use a column with a VARBINARY or BLOB binary string data type.
https://dev.mysql.com/doc/refman/8.4/en/error-log-rule-based-filtering.html
Both operators have the same precedence and evaluate left to right. The log_filter_dragnet log filter component enables log filtering based on user-defined rules. To enable the log_filter_dragnet filter, first load the filter component, then modify ...
https://dev.mysql.com/doc/refman/8.4/en/features.html
Support for LEFT OUTER JOIN and RIGHT OUTER JOIN with both standard SQL and ODBC syntax. These include both command-line programs such as mysqldump and mysqladmin, and graphical programs such as MySQL Workbench. This section describes some of the ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
If the call succeeds, the change in group membership is made to both the in-memory cache and persistent storage. If the call succeeds, the change in group membership is made to both the in-memory cache and persistent storage. When enabled, the ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-ngram.html
If a comma (“,”) is defined as a stopword, both “a,” and “,b” are excluded from the index because they contain a comma. Given two documents, one containing “ab” and the other containing “abc”, the search term “ab bc” matches ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/gis-mysql-specific-functions.html
Also, functions such as ST_GeomFromText() that accept WKT geometry collection arguments understand both OpenGIS 'GEOMETRYCOLLECTION EMPTY' standard syntax and MySQL 'GEOMETRYCOLLECTION()' nonstandard syntax. Also, functions such as ST_GeomFromText() ... MySQL provides a set of useful nonstandard functions for creating geometry ...
https://dev.mysql.com/doc/refman/8.4/en/gis-wkt-functions.html
For example, both of the following function calls are valid: ST_MPointFromText('MULTIPOINT (1 1, 2 2, 3 3)') ST_MPointFromText('MULTIPOINT ((1 1), (2 2), (3 3))') Functions such as ST_GeomFromText() that accept WKT geometry collection arguments ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
These syntax restrictions apply: GRANT cannot mix granting both privileges and roles in the same statement. It is permitted to assign both privileges and roles to an account, but you must use separate GRANT statements, each with syntax appropriate ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...