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/replication-compatibility.html
For example, foreign key names longer than 64 characters are no longer supported from MySQL 8.0. MySQL supports replication from one release series to the next higher release series. For example, you can replicate from a source running MySQL 5.6 to ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
Operations to watch out for include transactions involving multi-table UPDATE statements, triggers, cascading foreign keys, stored functions that update multiple tables, and DML statements that invoke stored functions that update one or more tables.
https://dev.mysql.com/doc/refman/5.7/en/show-engines.html
row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 2. SHOW [STORAGE] ENGINES SHOW ENGINES ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
Restrictions for Triggers For triggers, the following additional restrictions apply: Triggers are not activated by foreign key actions. Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
MySQL uses the tables found under http://www.unicode.org/Public/UCA/: UCA 4.0.0 table: http://www.unicode.org/Public/UCA/4.0.0/allkeys-4.0.0.txt This includes xxx_unicode_ci collations with no version number in the collation name. UCA 5.2.0 table: ... 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) ...
https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature.html
To verify the signature for a specific package, you first need to obtain a copy of our public GPG build key, which you can download from http://pgp.mit.edu/. After obtaining this key, you should compare it with the key shown following, before using ... Another method of verifying the integrity and authenticity of a package is to use cryptographic ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
The binary format is structured to enable the server to look up subobjects or nested values directly by key or array index without reading all values before or after them in the document. To display the desired value using mascot as the key, but ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-service.html
MySQL Server supports a keyring service that enables internal server components and plugins to securely store sensitive information for later retrieval. MySQL distributions provide a keyring interface that is accessible at two levels: At the SQL ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key files. Instructions for creating any required certificate and key files are available in Section ...