PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/blob.html
For example, if a table contains 'a', an attempt to store 'a ' causes a duplicate-key error. In some cases, it may be desirable to store binary data such as media files in BLOB or TEXT columns. A BLOB is a binary large object that can hold a ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-set.html
For the binary character set, the concepts of lettercase and accent equivalence do not apply: For single-byte characters stored as binary strings, character and byte boundaries are the same, so lettercase and accent differences are significant in ...
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 ...