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/faqs-tablespace-encryption.html
The master encryption key is rotated using the ALTER INSTANCE ROTATE INNODB MASTER KEY statement, which generates a new master encryption key, stores the key, and rotates the key into use. Is data decrypted for users who are authorized to see it? ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
If the insert exceeds this size, it is broken into multiple packets and the rollback problem can occur. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The ...
https://dev.mysql.com/doc/refman/5.7/en/fetch.html
This statement fetches the next row for the SELECT statement associated with the specified cursor (which must be open), and advances the cursor pointer. If a row exists, the fetched columns are stored in the named variables. The number of columns ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-elements.html
Server-side plugins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL_WHITELIST implement INFORMATION_SCHEMA tables that provide views into the registered profiles. MySQL Enterprise Firewall is based on a plugin library that includes these elements: A ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-information-schema-tables.html
The following sections describe the INFORMATION_SCHEMA tables associated with MySQL Enterprise Firewall (see Section 6.4.6, “MySQL Enterprise Firewall”). These tables are available only if the appropriate firewall plugins are enabled.
https://dev.mysql.com/doc/refman/5.7/en/floating-point-types.html
MySQL performs rounding when storing values, so if you insert 999.00009 into a FLOAT(7,4) column, the approximate result is 999.0001. The FLOAT and DOUBLE types represent approximate numeric data values. MySQL uses four bytes for single-precision ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-functions.html
The default return type of IF() (which may matter when it is stored into a temporary table) is calculated as follows: If expr2 or expr3 produce a string, the result is a string. The second syntax returns the result for the first condition that is ...
https://dev.mysql.com/doc/refman/5.7/en/foreign-key-optimization.html
If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the ...That way, each small table can have a primary key for fast lookups of its data, and you can query just the set of columns that you need using a join ...
https://dev.mysql.com/doc/refman/5.7/en/full-text-adding-collation.html
This section describes how to add a user-defined collation for full-text searches using the built-in full-text parser. The sample collation is like latin1_swedish_ci but treats the '-' character as a letter rather than as a punctuation character so ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-restrictions.html
For example, for an INSERT operation, an inserted string is tokenized and decomposed into individual words. Full-text searches are supported for InnoDB and MyISAM tables only. The exception is that for Unicode, the utf8 character set can be used, ...