PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/declare-cursor.html
A stored program may contain multiple cursor declarations, but each cursor declared in a given block must have a unique name. DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT statement ...
https://dev.mysql.com/doc/refman/8.0/en/declare.html
The DECLARE statement is used to define various items local to a program: Local variables. END compound statement and must be at its start, before any other statements. Variable and condition declarations must appear before cursor or handler ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
Descending indexes are supported for ordinary (nongenerated) and generated columns (both VIRTUAL and STORED). MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending order.
https://dev.mysql.com/doc/refman/8.0/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.0/en/drop-table.html
If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition definitions associated with the dropped table. Be careful with this statement! For each table, it ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
Similar to the system tablespace, truncating or dropping tables stored in a general tablespace creates free space internally in the general tablespace .ibd data file which can only be used for new InnoDB data. DROP [UNDO] TABLESPACE tablespace_name ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html
A row can become fragmented (stored in noncontiguous pieces) when it is made longer as a result of an update. Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table ...
https://dev.mysql.com/doc/refman/8.0/en/example-storage-engine.html
The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-c-api.html
What if I want to use the “NoSQL” X DevAPI? For C-language and X DevApi Document Store for MySQL, we recommend MySQL Connector/C++. What is “MySQL Native C API”? What are typical benefits and use cases? A.13.2. What if I want to use the ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-storage-engines.html
What are the unique benefits of the ARCHIVE storage engine? The ARCHIVE storage engine stores large amounts of data without indexes; it has a small footprint, and performs selects using table scans. Where can I obtain complete documentation for ...