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/create-procedure.html
The DEFINER clause specifies the MySQL account to be used when checking access privileges at routine execution time for routines that have the SQL SECURITY DEFINER characteristic. The CREATE FUNCTION statement is also used in MySQL to support ...By ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
Optimizer Hint Syntax MySQL supports comments in SQL statements as described in Section 11.7, “Comments”. Duplicate hints: For a hint such as /*+ MRR(idx1) MRR(idx1) */, MySQL uses the first hint and issues a warning about the duplicate hint.
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code modifications. Do not alter the MySQL sources unless you know what you are doing. Most full-text variables ...Modifying the default behavior in most cases can actually decrease ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-before-you-begin.html
If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it may be useful to create a test instance for assessing the conversions that are required and the work involved to perform ...The backup should include the mysql system database, which contains the MySQL data dictionary tables and system ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking.html
If you are using MySQL Enterprise Data Masking and De-Identification for the first time, consider installing the components for access to the ongoing enhancements only available with component infrastructure. Note MySQL Enterprise Data Masking and ...Generation of random data, such as email addresses and payment card ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the installation and debugging instructions in Section 2.1, “General Installation Guidance”, and Section 7.9, “Debugging MySQL”. Even if you use lower_case_table_names=2 (which enables MySQL to remember the case used for databases and table names), MySQL does not remember the case used for database names for the function DATABASE() or within the various logs (on case-insensitive ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. You can then transfer the file to the other machine and feed it as input to the mysql client. Note If ...
https://dev.mysql.com/doc/refman/8.0/en/debugging-client.html
To be able to debug a MySQL client with the integrated debug package, you should configure MySQL with -DWITH_DEBUG=1. Before running a client, you should set the MYSQL_DEBUG environment variable: $> MYSQL_DEBUG=d:t:O,/tmp/client.trace $> export ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions-legacy.html
In releases before MySQL 8.0.30, MySQL Enterprise Encryption's functions are based on the openssl_udf shared library. For information on upgrading to the new component functions provided by the MySQL component component_enterprise_encryption, and a ...The functions continue to be available in later releases if they have been installed, but they are ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation.html
For a list of macOS versions that the MySQL server supports, see https://www.mysql.com/support/supportedplatforms/database.html. MySQL for macOS is available in a number of different forms: Native Package Installer, which uses the native macOS ...