Search Results
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
rows (JSON name: rows) The rows column indicates the number of rows MySQL believes it must examine to execute the query. Scanned N databases (JSON property: message) This indicates how many directory scans the server performs when processing a query ...possible_keys (JSON name: possible_keys) The possible_keys column indicates the indexes from which MySQL can choose to find the rows in this ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-types.html
If you have questions or concerns about the use of the spatial extensions to MySQL, you can discuss them in the GIS forum: https://forums.mysql.com/list.php?23. The Open Geospatial Consortium publishes the OpenGIS® Implementation Standard for ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
The InnoDB INFORMATION_SCHEMA table interface allows you to query this data using SQL. The data in this table is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. mysql> INSERT INTO t1 VALUES(5, 'abc', ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-reading.html
To use the functions to read the audit log, follow these principles: Call audit_log_read() to read events beginning from a given position or the current position, or to close reading: To initialize an audit log read sequence, pass an argument that ... The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log ...(This capability does not apply to log files written in other formats.) When the audit log plugin initializes and is configured for JSON logging, it ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/internals/en/transactions-historical-note.html
"Statement transaction" is a non-standard term that comes from the days when MySQL supported the BerkeleyDB storage engine. First, observe that in BerkeleyDB the "auto-commit" mode causes automatic commit of operations that are atomic from the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-importing-data.html
It is common when setting up a new instance of NDB Cluster to need to import data from an existing NDB Cluster, instance of MySQL, or other source. This data is most often available in one or more of the following formats: An SQL dump file such as ...For more information about the latter, see Section 25.5.13, “ndb_import — Import CSV Data Into ...
https://dev.mysql.com/doc/internals/en/optimizer-group-by-related-conditions.html
(You can, however, rely on that rule with GROUP BY, unless the query includes ORDER BY NULL.) See: /sql/sql_select.cc, opt_sum_query(), and /sql/sql_select.cc, remove_duplicates(). If the table handler has a quick row-count available, then the query ... These are the main optimizations that take place for GROUP BY and related items (HAVING, COUNT(), MAX(), MIN(), SUM(), AVG(), ...
https://dev.mysql.com/doc/internals/en/frm-file-format.html
First, let's create an example table, using the mysql client: mysql> CREATE TABLE table1 (column1 CHAR(5)) ENGINE=MYISAM COMMENT '*'; Query OK, 0 rows affected (0.00 sec) The .frm file associated with table1 can be found in the directory that ...The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-content.html
The following sections in this topic describe how to generate new text-based content using MySQL HeatWave GenAI: Before You Begin Generate Content Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and ...To ...If you want to use the OCI Generative AI Service LLMs, complete the steps to authenticate OCI Generative AI ...