PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
Although a table must have at least one visible column, an index definition need not have any visible columns. An invisible column is normally hidden to queries, but can be accessed if explicitly referenced. As an illustration of when invisible ...
https://dev.mysql.com/doc/refman/8.0/en/key-space.html
This is for the worst case when all keys are inserted in sorted order and the table doesn't have any compressed keys. Numbers are stored with the high byte first, so this helps when you have many integer keys that have an identical prefix. You can ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-key-migration.html
The account used to connect to the running server must have the privileges required to modify keyring_operations. The user a server in key-migration mode runs as must have permission to read and write any local keyring files, such as the data file ... A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different ...
https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html
After the initial rows have been found, MySQL does not sort any remainder of the result set. If multiple rows have identical values in the ORDER BY columns, the server is free to return those rows in any order, and may do so differently depending on ... If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html
The full names for the RPMs have the following syntax: packagename-version-distribution-arch.rpm The distribution and arch values indicate the Linux distribution and the processor type for which the package was built. Notes The mysql user is created ... The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
For example, to install MySQL 8.0, make sure you have enabled=0 for the other MySQL series entries and enabled=1 for MySQL 8.0. Once you have installed MySQL using the MySQL Yum repository, you cannot install these packages (and vice versa). Before ...
https://dev.mysql.com/doc/refman/8.0/en/load-data-local-security.html
To avoid LOAD DATA issues, clients should avoid using LOCAL unless proper client-side precautions have been taken. Clients that make no explicit arrangements therefore have LOCAL capability disabled or enabled according to the ENABLED_LOCAL_INFILE ... The LOAD DATA statement loads a data file into a ...
https://dev.mysql.com/doc/refman/8.0/en/locale-support.html
Locale names have language and region subtags listed by IANA (http://www.iana.org/assignments/language-subtag-registry) such as 'ja_JP' or 'pt_BR'. The default value is 'en_US' regardless of your system's locale setting, but you can set the value at ... The locale indicated by the lc_time_names system variable controls the language used to display day and month names and ...
https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
(This assumes that the general query log itself is enabled.) Log Table Benefits and Characteristics The use of tables for log output offers the following benefits: Log entries have a standard format. For users who have access to the .CSV files that ... MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (col1, col2), and (col1, col2, col3). MySQL can create composite indexes (that is, indexes on multiple columns). For certain data ...