Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per ...
https://dev.mysql.com/doc/refman/8.4/en/comments.html
MySQL Server supports three comment styles: From a # character to the end of the line. In MySQL, the -- (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character, such as a space or tab.
https://dev.mysql.com/doc/refman/8.4/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... The ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-security.html
Where can I find documentation that addresses security issues for MySQL? A.9.2. Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? A.9.5. Does MySQL include support for Roles Based Access Control (RBAC)? ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Where can I find documentation for MySQL stored procedures and stored functions? A.4.3. Where can I find the ANSI SQL 2003 specification for stored procedures? A.4.5. Is there a way to view all stored procedures and stored functions in a given ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search.html
MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
The following list describes thread State values that are associated with general query processing and not more specialized activities such as replication. Many of these are useful only for finding bugs in the server. After create This occurs when ...
https://dev.mysql.com/doc/refman/8.4/en/gis-general-property-functions.html
The functions listed in this section do not restrict their argument and accept a geometry value of any type. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL, the return value ...
https://dev.mysql.com/doc/refman/8.4/en/gis-polygon-property-functions.html
Functions in this section return properties of Polygon or MultiPolygon values. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, ...