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/charset-unicode-utf32.html
The utf32 character set is fixed length (like ucs2 and unlike utf16). utf32 uses 32 bits for every character, unlike ucs2 (which uses 16 bits for every character), and unlike utf16 (which uses 16 bits for some characters and 32 bits for others).
https://dev.mysql.com/doc/refman/5.7/en/declare-local-variable.html
If the DEFAULT clause is missing, the initial value is NULL. type [DEFAULT value] This statement declares local variables within stored programs. To provide a default value for a variable, include a DEFAULT clause. The value can be specified as an ...
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/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/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.