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/merge-storage-engine.html
“Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM tables in which the columns are listed in a different order, do not have exactly the same data types in corresponding columns, or ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. The ENUM type has these advantages: Compact data storage in situations where a column ...See Section 11.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-comments.html
In this case, the generated statement looks like this: UPDATE account SET balance=balance--1 WHERE account_id=5752; balance--1 is valid standard SQL, but -- is interpreted as the start of a comment, and part of the expression is discarded. Standard ...
https://dev.mysql.com/doc/refman/5.7/en/channels-with-prev-replication.html
When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For example, the following statements behave as expected for all ...
https://dev.mysql.com/doc/refman/5.7/en/cursor-restrictions.html
A server-side cursor enables a result set to be generated on the server side, but not transferred to the client except for those rows that the client requests. You cannot use a cursor for a statement that generates a result set if the statement is ... Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
Client-side error messages are generated from within the MySQL client library, usually involving problems communicating with the server. Example server-side error messages written to the error log: This message produced during the startup process ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-enabling-monitors.html
InnoDB monitors should only be enabled when you actually want to see monitor information because output generation causes some performance decrement. The --innodb-status-file option is intended for temporary use, as output generation can affect ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-aws-plugin.html
The keyring_aws keyring plugin communicates with the Amazon Web Services Key Management Service (AWS KMS) as a back end for key generation and uses a local file for key storage. All keyring material is generated exclusively by the AWS server, not by ... Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-okv-plugin.html
Keyring material is generated exclusively by the back end, not by keyring_okv. Example (using the SQL interface): SELECT keyring_key_generate('MyKey', 'AES', 32); SELECT keyring_key_remove('MyKey'); For information about the characteristics of key ... Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
An SSL certificate and key files are generated in the data directory. The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by Oracle. There are two sources for obtaining them, for the Community ...