PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
In-Place Downgrade Logical Downgrade In-Place Downgrade In-place downgrade involves shutting down the new MySQL version, replacing the new MySQL binaries or packages with the old ones, and restarting the old MySQL version on the existing data ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
By default, the <row> element is considered to be the equivalent of a database table row; this can be changed using the ROWS IDENTIFIED BY clause. (Bug #30753708, Bug #98199) The following clauses work essentially the same way for LOAD XML as they ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
For supplementary characters in general collations, the weight is the weight for 0xfffd REPLACEMENT CHARACTER. This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range possible_keys: gc key: gc key_len: 5 ref: NULL rows: 1 filtered: 100.00 Extra: Using index condition In effect, the optimizer has replaced the ...For ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-problems.html
Because the MERGE engine cannot enforce uniqueness over the set of underlying tables, REPLACE does not work as expected. The two key facts are: REPLACE can detect unique key violations only in the underlying table to which it is going to write ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-linux-rpm.html
This section covers the steps necessary to install the correct executables for each type of NDB Cluster node using RPM packages supplied by Oracle. As an alternative to the method described in this section, Oracle provides MySQL Repositories for ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-locking.html
REPLACE and INSERT lock only those partitions having rows to be inserted or replaced. In MySQL 5.7, partition lock pruning eliminates unneeded locks in many cases, and most statements reading from or updating a partitioned MyISAM table cause only ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
Be aware that, if your application uses REPLACE statements and you do this, the results of these statements can be drastically altered. See Section 13.2.8, “REPLACE Statement”, for more information and an example. This section discusses current ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
The correct way to remove them is to replace them with TRUE, so that we do not miss any matching rows when doing the range scan. The range access method uses a single index to retrieve a subset of table rows that are contained within one or several ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
Replace the password with the password that you want to use. Replace the password with the password that you want to use. Replace the password with the password that you want to use. If you have never assigned a root password for MySQL, the server ...