Search Results
https://dev.mysql.com/doc/refman/8.4/en/spatial-geohash-functions.html
The functions in this section enable manipulation of geohash values, which provides applications the capabilities of importing and exporting geohash data, and of indexing and searching geohash values. Unless otherwise specified, functions in this ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
NDB (also known as NDBCLUSTER): This clustered database engine is particularly suited for applications that require the highest possible degree of uptime and availability. Example: This engine serves as an example in the MySQL source code that ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
This account must have the EXECUTE privilege for p1 as well as the UPDATE privilege for the table t1 referenced within the object body. In this case, the account “adopts” the object and, with the appropriate privileges, is able to execute it ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
This is true even for strings that are preceded by an introducer that indicates a different character set, as discussed in Section 12.3.6, “Character String Literal Character Set and Collation”. The \% and \_ sequences are used to search for ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
row *************************** QUERY: SELECT SUM(alias2.col_varchar_nokey) AS c1, alias2.pk AS c2 FROM t1 AS alias1 STRAIGHT_JOIN t2 AS alias2 ON alias2.pk = alias1.col_int_key WHERE alias1.pk GROUP BY c2 ORDER BY alias1.col_int_key, alias2.pk This ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G ...
https://dev.mysql.com/doc/refman/8.4/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. | ...The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
WITH followed by WITH at the same level is not permitted, so this is illegal: WITH cte1 AS (...) WITH cte2 AS (...) SELECT ... This is illegal: WITH cte1 AS (...), cte1 AS (...) SELECT ... This constraint rules out mutually-recursive CTEs, where ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
If this happens in a table's constraints, default expressions, partitioning expressions, or virtual columns, the table could not be opened. This prevented both analyzing the problem (using, for example, SHOW CREATE TABLE) and addressing it (such as ...(Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-incremental-options.html
This is potentially the fastest way for mysqlbackup to create incremental backups. If this value has been set explicitly but page tracking cannot be used, the backup fails with an error. Some restrictions apply when this option is employed; see ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-single-file-options.html
If this is not specified, operating system-specific search methods are used to locate libobk.so (UNIX) or orasbt.dll (Windows). This option specifies the destination path for the entry selected from the backup image by --src-entry. You use them in ...