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/example-maximum-row.html
Task: Find the number, dealer, and price of the most expensive article.
https://dev.mysql.com/doc/refman/5.7/en/exists-and-not-exists-subqueries.html
For the preceding example, if t2 contains any rows, even rows with nothing but NULL values, the EXISTS condition is TRUE. If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For example: SELECT column1 ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
MySQL Server supports some extensions that are likely not to be found in other SQL DBMSs. Be warned that if you use them, your code is not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) issues. What problems should I be aware of when working with the Big5 ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
A function is nondeterministic if, given fixed values for its arguments, it can return different results for different invocations. If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-launching.html
It should show something like this: mysql> SHOW PLUGINS; +----------------------------+----------+--------------------+----------------------+-------------+ | Name | Status | Type | Library | License | ... It is first necessary to ensure that the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html
Every table that is to be replicated by the group must have a defined primary key, or primary key equivalent where the equivalent is a non-null unique key. Server instances that you want to use for Group Replication must satisfy the following ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
A search using col_name IS NULL employs indexes if col_name is indexed. Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data structures in their indexes, ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-plugins-table.html
If the library name is NULL, the plugin is compiled in and cannot be uninstalled with UNINSTALL PLUGIN. The PLUGINS table has these columns: PLUGIN_NAME The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN.