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/clone-plugin-local.html
An absolute path is required, and the specified directory (“clone_dir”) must not exist, but the specified path must be an existent path. Cloning a tablespace with the same path as the source tablespace would cause a conflict and is therefore ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin.html
The plugin library contains two plugins: CONNECTION_CONTROL checks incoming connection attempts and adds a delay to server responses as necessary. This plugin also exposes system variables that enable its operation to be configured and a status ...
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...
https://dev.mysql.com/doc/refman/8.0/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...DROP TABLE causes an implicit commit, except when used with the TEMPORARY ...
https://dev.mysql.com/doc/refman/8.0/en/drop-user.html
The DROP USER statement removes one or more MySQL accounts and their privileges. Roles named in the mandatory_roles system variable value cannot be dropped. DROP USER either succeeds for all named users or rolls back and has no effect if any error ...It removes privilege rows for the account from all grant ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption.html
Note MySQL Enterprise Encryption is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes a set of encryption functions that expose OpenSSL capabilities at the SQL level. From MySQL 8.0.30, they ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-storage-engines.html
Is there an advantage to using the InnoDB storage engine exclusively, as opposed to a combination of InnoDB and non-InnoDB storage engines? A.2.6. That chapter contains information about all MySQL storage engines except for the InnoDB storage engine ...Where can I obtain complete documentation for MySQL storage engines? ...
https://dev.mysql.com/doc/refman/8.0/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 ...MySQL also supports this optional precision specification, but the precision value in FLOAT(p) is used only to determine storage ...
https://dev.mysql.com/doc/refman/8.0/en/gis-mysql-specific-functions.html
MySQL provides a set of useful nonstandard functions for creating geometry values. Also, functions such as ST_GeomFromText() that accept WKT geometry collection arguments understand both OpenGIS 'GEOMETRYCOLLECTION EMPTY' standard syntax and MySQL ...The functions described in this section are MySQL extensions to the OpenGIS ...
https://dev.mysql.com/doc/refman/8.0/en/gis-point-property-functions.html
A Point consists of X and Y coordinates, which may be obtained using the ST_X() and ST_Y() functions, respectively. For Point objects that have a geographic spatial reference system (SRS), the longitude and latitude may be obtained using the ...