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/checking-gpg-signature.html
The signature file has the same name as the distribution file with an .asc extension, as shown by the examples in the following table. Here are explanations for these warnings: gpg: no ultimately trusted keys found: This means that the specific key ... Another method of verifying the integrity and authenticity of a package is to use cryptographic ...
https://dev.mysql.com/doc/refman/8.0/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-triggers.html
Is there a way to view all triggers in a given database? A.5.7. Is there a way to view all triggers in a given database? Yes. You can obtain a listing of all triggers defined on database dbname using a query on the INFORMATION_SCHEMA.TRIGGERS table ...Where can I find the documentation for MySQL 8.0 triggers? ...Is it ...
https://dev.mysql.com/doc/refman/8.0/en/set.html
A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. Duplicate values in the definition cause a warning, or an error if strict SQL mode is ...A ...SET column values that consist of multiple set members are specified with members separated by commas ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning.html
Nothing further needs to be done to enable partitioning support by InnoDB (for example, no special entries are required in the my.cnf file). In MySQL 8.0, partitioning support is provided by the InnoDB and NDB storage engines. MySQL 8.0 does not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-encrypted-connections.html
To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network connections. You must obtain (or create) a suitable security certificate that you ...If either server does not support encrypted connections (because it has not been compiled or configured for them), replication through an encrypted connection is not ...
https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html
If a statement or condition item is not set by a statement that populates the diagnostics area, its value is 0 or the empty string, depending on the item data type. MESSAGE_TEXT: A string that indicates the error message for the condition. SQL ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. In MySQL 8.0.21 and later, the data type returned by ROUND() (and TRUNCATE()) is determined according to the ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
Hints are permitted in these contexts: At the beginning of query and data change statements: SELECT /*+ ... If a table has an alias, hints must refer to the alias, not the table name. Note To use a block nested loop or batched key access hint to ...
https://dev.mysql.com/doc/refman/8.0/en/batch-mode.html
If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Just edit your script to correct the error, then tell mysql to execute it again. In the previous sections, you ...Why use a script? Here are a few reasons: If you run a query repeatedly (say, every day or every week), making it a script enables you to avoid retyping it each time you execute ...