Search Results
https://dev.mysql.com/doc/refman/8.4/en/execution-plan-information.html
Depending on the details of your tables, columns, indexes, and the conditions in your WHERE clause, the MySQL optimizer considers many techniques to efficiently perform the lookups involved in an SQL query. A query on a huge table can be performed ...
https://dev.mysql.com/doc/refman/8.4/en/explain-extended.html
The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following EXPLAIN. Extended information is available for SELECT, DELETE, INSERT, REPLACE, ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-connectors-apis.html
For common questions, issues, and answers relating to the MySQL Connectors and other APIs, see the following areas of the Manual: Using C API Features Connector/ODBC Notes and Tips Connector/NET Programming MySQL Connector/J Developer Guide .
https://dev.mysql.com/doc/refman/8.4/en/faqs-migration.html
Where can I find information on how to upgrade or downgrade MySQL? A.8.1. Where can I find information on how to upgrade or downgrade MySQL? For detailed upgrade information, see Chapter 3, Upgrading MySQL. Do not skip a major version when ...
https://dev.mysql.com/doc/refman/8.4/en/fetch.html
This statement fetches the next row for the SELECT statement associated with the specified cursor (which must be open), and advances the cursor pointer. If a row exists, the fetched columns are stored in the named variables. The number of columns ...
https://dev.mysql.com/doc/refman/8.4/en/file-permissions.html
If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld starts. For example, mysqld might issue the following error message when you create a table: ERROR: Can't find file: ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-information-schema-tables.html
The following sections describe the INFORMATION_SCHEMA tables associated with MySQL Enterprise Firewall (see Section 8.4.7, “MySQL Enterprise Firewall”). These tables are available only if the appropriate firewall plugins are enabled.
https://dev.mysql.com/doc/refman/8.4/en/firewall.html
Note MySQL Enterprise Firewall is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or ...
https://dev.mysql.com/doc/refman/8.4/en/fixed-point-types.html
The DECIMAL and NUMERIC types store exact numeric data values. These types are used when it is important to preserve exact precision, for example with monetary data. In MySQL, NUMERIC is implemented as DECIMAL, so the following remarks about ...
https://dev.mysql.com/doc/refman/8.4/en/floating-point-types.html
The FLOAT and DOUBLE types represent approximate numeric data values. MySQL uses four bytes for single-precision values and eight bytes for double-precision values. For FLOAT, the SQL standard permits an optional specification of the precision (but ...