PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
For SET or ENUM values, the cast operation causes the underlying numeric value to be used. mysql> SELECT student_name, MIN(test_score), MAX(test_score) FROM student GROUP BY student_name; For MAX(), MySQL currently compares ENUM and SET columns by ... This section describes aggregate functions that operate on sets of ...If you use an aggregate function in a statement ...
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
The functions in this section perform search operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. A candidate object is contained in a target object if ...
https://dev.mysql.com/doc/refman/5.7/en/not-enough-file-handles.html
There is also a “hard” limit that can be overridden only if you start mysqld_safe or mysqld as root (just remember that you also need to start the server with the --user option in this case so that it does not continue to run as root after it ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-variables.html
System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program context. It is not permitted to assign the value DEFAULT to stored procedure or function parameters or stored program local ...For information about the scope of local variables and how MySQL resolves ambiguous names, see Section 13.6.4.2, “Local Variable Scope and ...In addition, stored programs can use DECLARE to define local ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 4.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html
Before MySQL 5.7.9, selecting from the INFORMATION_SCHEMA tables produces an empty result set plus a deprecation warning. The INFORMATION_SCHEMA has tables that contain system and status variable information (see Section 24.3.11, “The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-bugs.html
When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug report. If you have a “phantom” problem (one that you cannot duplicate at will), use ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
For most users, the mixed replication format should provide the best combination of data integrity and performance. Note Statements that update the information in the mysql system database, such as GRANT, REVOKE and the manipulation of triggers, ...
https://dev.mysql.com/doc/refman/5.7/en/windows-choosing-package.html
Other platforms are not supported, and users running the MySQL Docker images from Oracle on them are doing so at their own risk. The package formats described in this section are: MySQL Installer MySQL noinstall ZIP Archives MySQL Docker Images ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
You can access the underlying InnoDB table through SQL for reporting, analysis, ad hoc queries, bulk loading, multi-step transactional computations, set operations such as union and intersection, and other operations suited to the expressiveness and ...Running memcached in the same process space as the MySQL server avoids the network overhead of passing requests back and ...