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/partitioning-info.html
This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used ...
https://dev.mysql.com/doc/refman/5.7/en/perl-support-problems.html
If you get the following errors from DBD::mysql, you are probably using gcc (or using an old binary compiled with gcc): /usr/bin/perl: can't resolve symbol '__moddi3' /usr/bin/perl: can't resolve symbol '__divdi3' Add -L/usr/lib/gcc-lib/... If Perl ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-rounding.html
Such truncation is not an error, even in strict SQL mode (see Section 12.21.3, “Expression Handling”). This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and ...
https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html
For example, an error in a collation might have been corrected, necessitating a table rebuild to update the indexes for character columns that use the collation. This section describes how to rebuild or repair tables or indexes, which may be ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser does not seem quite right. Consulting your original pedigree papers, you find that the correct birth year should be 1989, not 1979. Fix only the erroneous record with an UPDATE ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-installation.html
If a plugin fails to initialize, check the server error log for diagnostic messages. This section describes how to install MySQL Enterprise Thread Pool. For general information about installing plugins, see Section 5.5.1, “Installing and ...
https://dev.mysql.com/doc/refman/5.7/en/updating-direct-rpms.html
It is preferable to use the MySQL Yum repository or MySQL SLES Repository to upgrade MySQL on RPM-based platforms. For an upgrade installation using RPM packages, the MySQL server is automatically restarted at the end of the installation if it was ...
https://dev.mysql.com/doc/refman/5.7/en/year.html
In strict SQL mode, attempting to insert an invalid YEAR value produces an error. The YEAR type is a 1-byte type used to represent year values. It can be declared as YEAR with an implicit display width of 4 characters, or equivalently as YEAR(4) ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
The second query performs a full table scan, which might be faster than the index lookup if the search term was present in most rows. MyISAM Limitation For very small tables, word distribution does not adequately reflect their semantic value, and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-added-deprecated-removed-7-5.html
DiskCheckpointSpeedInRestart: Bytes allowed to be written by checkpoint during restart, per second. Parameters Introduced in NDB 7.5 The following node configuration parameters have been added in NDB 7.5. Parameters Deprecated in NDB 7.5 The ...