Search Results
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions. There are also some restrictions specific to stored functions but not to stored procedures. The restrictions for stored ...
https://dev.mysql.com/doc/refman/8.4/en/string-comparison-functions.html
To search for \, specify it as \\\\; this is because the backslashes are stripped once by the parser and again when the pattern match is made, leaving a single backslash to be matched against. Table 14.13 String Comparison Functions and Operators ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
Any errors in the value cause the assignment to fail with an error, leaving the value of optimizer_switch unchanged. Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
This section describes how to upgrade MySQL binary and package-based installations on Unix/Linux. In-Place Upgrade Logical Upgrade MySQL Cluster Upgrade In-Place Upgrade An in-place upgrade involves shutting down the old MySQL server, replacing the ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
The following statement changes the query limit for francis to 100: mysql> ALTER USER 'francis'@'localhost' WITH MAX_QUERIES_PER_HOUR 100; The statement modifies only the limit value specified and leaves the account otherwise unchanged. One means ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-installation.html
Upgrades to MySQL 8.4 from 8.3 using Yum or RPM packages leave the validate_password plugin in place. This section describes how to install and uninstall the validate_password password-validation component. For general information about installing ...
https://dev.mysql.com/doc/refman/8.4/en/where-optimization.html
Because MySQL does similar optimizations automatically, you can often avoid this work, and leave the query in a more understandable and maintainable form. This section discusses optimizations that can be made for processing WHERE clauses. The ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-service.html
Warning You must exercise great care when editing your system PATH by hand; accidental deletion or modification of any portion of the existing PATH value can leave you with a malfunctioning or even unusable system. On Windows, the recommended way ...
https://dev.mysql.com/doc/refman/8.4/en/windows-troubleshooting.html
This enables the new service to be installed correctly, but leaves the outdated service in place. When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. This section helps ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/partial.html
Leaving out files that are present in the MySQL data directory but not actually part of the MySQL instance. By default, all the files under the database subdirectories in the data directory are included in the backup, so that the backup includes ...