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/scalar-subqueries.html
A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those characteristics that all operands have: a data type, a length, an indication that it can be ...
https://dev.mysql.com/doc/refman/8.0/en/server-configuration-validation.html
For additional checks to occur, correct the initial problem and run the server with --validate-config again. This command produces the same warnings, but also an error, so the error message is displayed along with the warnings and the exit code is ... As of MySQL 8.0.16, MySQL Server supports a --validate-config option that enables the startup configuration to be checked for problems without running the server in normal operational mode: mysqld --validate-config If no errors are found, the server terminates with an exit code of ...
https://dev.mysql.com/doc/refman/8.0/en/server-configuration.html
The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command: $> mysqld ...
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-example.html
Assume that data is stored in the InnoDB storage engine, which has support for transactions and automatic crash recovery. Assume also that the MySQL server is under load at the time of the crash. The InnoDB data files might not contain consistent ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html
For existing rows, only the ENABLED and TIMED columns can be modified, by users with the UPDATE privilege on the table. The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and TIMED ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise-monitor.html
Important MySQL Enterprise Monitor will be end of life and deprecated with obsolescence as of January 1, 2025. After this date, MySQL Enterprise Monitor will no longer receive security updates, non-security updates, bug fixes, or online technical ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
(In this case, simply using PARTITION BY KEY() would also be valid and have the same effect as PARTITION BY KEY(s1), since s1 is the table's primary key.) For additional information about this issue, see Section 26.6, “Restrictions and Limitations ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management.html
There are also ways to obtain information about partitioned tables and partitions. For information about partition management in tables partitioned by RANGE or LIST, see Section 26.3.1, “Management of RANGE and LIST Partitions”. For a discussion ... There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/year.html
Note As of MySQL 8.0.19, the YEAR(4) data type with an explicit display width is deprecated and you should expect support for it to be removed in a future version of MySQL. For instructions on converting to 4-digit YEAR, see 2-Digit YEAR(2) ... The ...
https://dev.mysql.com/doc/refman/8.0/en/character-arrays.html
<collation> elements indicate character ordering for comparison and sorting, one element per collation. For a complex character set as implemented in a ctype-MYSET.c file in the strings directory, there are corresponding arrays: ctype_MYSET[], ...