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/compressed-format.html
Numbers with a value of zero are stored using one bit. If values in an integer column have a small range, the column is stored using the smallest possible type. For example, a BIGINT column (eight bytes) can be stored as a TINYINT column (one byte) ... Compressed storage format is a read-only format that is generated with the myisampack ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
In the following commands, DUMPDIR represents the full path name of the directory you use to store the output from mysqldump. In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file ...
https://dev.mysql.com/doc/refman/8.0/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. When you store data into the table, the storage engine saves it into the data file in comma-separated values format. The CSV storage engine is always compiled ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html
In previous MySQL releases, dictionary data was partially stored in metadata files. Unless otherwise noted, data previously stored in metadata files is now stored in data dictionary tables. Issues with file-based metadata storage included expensive ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory.html
Information managed by the MySQL server is stored under a directory known as the data directory. The ndbinfo directory corresponds to the ndbinfo database that stores information specific to NDB Cluster (present only for installations built to ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking.html
Substitution of data by data from dictionaries stored in the database. This may include genetic sequences (long strings), test results stored in JSON format, and other data types. Note MySQL Enterprise Data Masking and De-Identification is an ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: 2013-09-24T12:41:31.261992Z 25 [ERROR] Event Scheduler: [jon@ghidora][cookbook.e_store_ts] INSERT command ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.0/en/federated-description.html
A FEDERATED table consists of two elements: A remote server with a database table, which in turn consists of the table definition (stored in the MySQL data dictionary) and the associated table. To read a result set, it uses mysql_store_result() and ... When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated ...
https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html
Here, (M,D) means than values can be stored with up to M digits in total, of which D digits may be after the decimal point. Because floating-point values are approximate and not stored as exact values, attempts to treat them as exact in comparisons ... The FLOAT and DOUBLE types represent approximate numeric data ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
Note The syntax of the CASE operator described here differs slightly from that of the SQL CASE statement described in Section 15.6.5.1, “CASE Statement”, for use inside stored programs. The default return type of IF() (which may matter when it ...The second syntax returns the result for the first condition that is ...