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/mysql-indexes.html
Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. If the table has an index for the columns in question, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string ...
https://dev.mysql.com/doc/refman/8.0/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. NDB Cluster uses MD5() for this purpose; for ...
https://dev.mysql.com/doc/refman/8.0/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to attributes associated with a data type, or to an index specification. All changes are ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-get-config.html
Given a configuration option name, returns the option value from the sys_config table, or the provided default value (which may be NULL) if the option does not exist in the table. If sys_get_config() returns the default value and that value is ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL. Tested with Purify (a commercial memory leakage detector) as well as with Valgrind, a GPL ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to group values into subsets. If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to ...