PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/data-types.html
MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. This chapter provides an overview and more detailed description of the properties of ...For floating-point and fixed-point types, M is the total number of digits that can be stored (the ...
https://dev.mysql.com/doc/refman/8.0/en/data-change-optimization.html
Data analysis and reporting applications typically run data change operations that affect many rows at once, where the main considerations is the I/O to write large amounts of data and keep indexes up-to-date. For inserting and updating large ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-compressed-data.html
The following requirements apply when cloning remote data: The recipient file system must support sparse files and hole punching for hole punching to occur on the recipient. The donor and recipient file systems must have the same block size. If file ...For information about the page compression feature, see Section 17.9.2, “InnoDB Page ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). This section describes how to install or uninstall MySQL Enterprise Data Masking and ...If ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-invalid-data.html
By default, MySQL 8.0 rejects invalid or improper data values and aborts the statement in which they occur. It is possible to alter this behavior to be more forgiving of invalid values, such that the server coerces them to valid ones for data ...
https://dev.mysql.com/doc/refman/8.0/en/fetching-spatial-data.html
Fetching spatial data in internal format: Fetching geometry values using internal format can be useful in table-to-table transfers: CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM geom; Fetching spatial data in WKT format: The ST_AsText() function ...
https://dev.mysql.com/doc/refman/8.0/en/windows-initialize-data-directory.html
If you installed MySQL using the noinstall package, no data directory is included. To initialize the data directory, use the instructions at Section 2.9.1, “Initializing the Data Directory”.
https://dev.mysql.com/doc/refman/8.0/en/perror.html
perror displays the error message for MySQL or operating system error codes. For example, for the ER_WRONG_VALUE_FOR_VAR error, perror understands any of these arguments: 1231, 001231, MY-1231, or MY-001231, or ER_WRONG_VALUE_FOR_VAR. The meaning ...A given error code may mean different things on different operating ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-limitations.html
This section describes temporary limitations introduced with the MySQL data dictionary. Manual creation of database directories under the data directory (for example, with mkdir) is unsupported. Manually created database directories are not ...DDL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-error-messages.html
The error_messages table provides information about The error_messages table contains the following columns: error_code Numeric error code error_description Description of error error_status Error status code error_classification Error ...