PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
If the default database is dropped, the default database is unset (the DATABASE() function returns NULL). DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. Be very careful with ...
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 ...