Search Results
https://dev.mysql.com/doc/refman/8.4/en/cursor-restrictions.html
Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A server-side cursor enables a result set to be generated on the server side, but not transferred to the client except for those rows that the client ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
A menagerie distribution containing some of the queries and sample data used in the following sections can be obtained from the MySQL website. Once you know how to enter SQL statements, you are ready to access a database. Suppose that you have ...
https://dev.mysql.com/doc/refman/8.4/en/debugging-client.html
To be able to debug a MySQL client with the integrated debug package, you should configure MySQL with -DWITH_DEBUG=1. Before running a client, you should set the MYSQL_DEBUG environment variable: $> MYSQL_DEBUG=d:t:O,/tmp/client.trace $> export ...
https://dev.mysql.com/doc/refman/8.4/en/descending-indexes.html
Indexes that have descending key parts are not used for MIN()/MAX() optimization of queries that invoke aggregate functions but do not have a GROUP BY clause. MySQL supports descending indexes: DESC in an index definition is no longer ignored but ...
https://dev.mysql.com/doc/refman/8.4/en/describe.html
The DESCRIBE and EXPLAIN statements are synonyms, used either to obtain information about table structure or query execution plans. For more information, see Section 15.7.7.6, “SHOW COLUMNS Statement”, and Section 15.8.2, “EXPLAIN ...
https://dev.mysql.com/doc/refman/8.4/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). It cannot be used ...
https://dev.mysql.com/doc/refman/8.4/en/document-store-concepts.html
In terms of MySQL this means: Create a new document (insertion or addition) Read one or more documents (queries) Update one or more documents Delete one or more documents . This section explains the concepts introduced as part of using MySQL as a ...
https://dev.mysql.com/doc/refman/8.4/en/document-store-interfaces.html
You can use MySQL Shell to prototype applications, execute queries and update data. To work with MySQL as a document store, you use dedicated components and a choice of clients that support communicating with the MySQL server to develop document ...
https://dev.mysql.com/doc/refman/8.4/en/drop-spatial-reference-system.html
DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data dictionary. Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the ...
https://dev.mysql.com/doc/refman/8.4/en/error-log.html
Depending on error log configuration, error messages may also populate the Performance Schema error_log table, to provide an SQL interface to the log and enable its contents to be queried. This section discusses how to configure the MySQL server ...