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/command-line-options.html
For example: $> mysql -u root -p -e "SELECT VERSION();SELECT NOW()" Enter password: ****** +------------+ | VERSION() | +------------+ | 8.0.19 | +------------+ +---------------------+ | NOW() | +---------------------+ | 2019-09-03 10:36:48 | ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
Prior to version 8.0.20, when processing SELECT and other SQL statements, NDB compared the names of foreign keys in such statements with the names as stored in a case-sensitive fashion when lower_case_table_names was equal to 0. Example queries are ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-files-using-openssl.html
During installation, leave the default C:\OpenSSL-Win32 as the install path, and also leave the default option 'Copy OpenSSL DLL files to the Windows system directory' selected. When the installation has finished, add C:\OpenSSL-Win32\bin to the ...
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
If the program was called by another stored program, the calling program handles the condition using the handler selection rules applied to its own handlers. HANDLER statement had not been present, MySQL would have taken the default action (EXIT) ...
https://dev.mysql.com/doc/refman/8.0/en/distinct-optimization.html
Because DISTINCT may use GROUP BY, learn how MySQL works with columns in ORDER BY or HAVING clauses that are not part of the selected columns. In the following case, assuming that t1 is used before t2 (which you can check with EXPLAIN), MySQL stops ... DISTINCT combined with ORDER BY needs a temporary table in many ...
https://dev.mysql.com/doc/refman/8.0/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. It cannot be used in all cases where SELECT can be used. DO is useful primarily with functions that have ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
MySQL connectors and clients select the highest TLS version available by default. From MySQL 8.0.19, you can use the options to configure client support for any selection of ciphersuites, including only non-default ciphersuites if you want. Do not ... MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for encrypted ...
https://dev.mysql.com/doc/refman/8.0/en/example-maximum-row.html
Task: Find the number, dealer, and price of the most expensive article.
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
There is no user-facing mechanism for influencing this selection, which is completely automatic; the fact that it is automatic is a key part of NDB Cluster's internal architecture. However, it also means that queries that could otherwise use range ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
This operation has no effect on tables used for the general query log (see Section 7.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”). This operation has no effect on tables used for the slow query log (see Section ...| ...