PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/condition-handling-restrictions.html
In MySQL, this is not guaranteed, so to get the main error, you cannot do this: GET DIAGNOSTICS CONDITION 1 @errno = MYSQL_ERRNO; Instead, do this: GET DIAGNOSTICS @cno = NUMBER; GET DIAGNOSTICS CONDITION @cno @errno = MYSQL_ERRNO; . SIGNAL, ...
https://dev.mysql.com/doc/refman/8.0/en/condition-handling.html
For information about the diagnostics area, see Section 15.6.7.7, “The MySQL Diagnostics Area”. Conditions may arise during stored program execution that require special handling, such as exiting the current program block or continuing ...
https://dev.mysql.com/doc/refman/8.0/en/connection-management.html
This includes a description of the available connection interfaces, how the server uses connection handler threads, details about the administrative connection interface, and management of DNS lookups.
https://dev.mysql.com/doc/refman/8.0/en/controlling-optimizer.html
MySQL provides optimizer control through system variables that affect how query plans are evaluated, switchable optimizations, optimizer and index hints, and the optimizer cost model. The server maintains histogram statistics about column values in ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html
Tables created in the mysql tablespace, the InnoDB system tablespace (innodb_system), or general tablespaces include a TABLESPACE attribute in the table definition, which defines the tablespace where the table resides. LIKE to create an empty table ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. See also the notes about spatial indexes under ...
https://dev.mysql.com/doc/refman/8.0/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/8.0/en/displaying-traces.html
Examining a trace in the mysql command-line client can be made less difficult using the pager less command (or your operating platform's equivalent). INTO DUMPFILE is preferable to INTO OUTFILE for this purpose, since the latter escapes newlines.
https://dev.mysql.com/doc/refman/8.0/en/drop-role.html
As of MySQL 8.0.16, users who have the CREATE USER privilege can use this statement to drop accounts that are locked or unlocked. DROP ROLE removes one or more roles (named collections of privileges). To use this statement, you must have the global ...
https://dev.mysql.com/doc/refman/8.0/en/drop-server.html
DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER is not ...