MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 1821 to 1826 of 1826 total results

« Previous
181
182
183
Next »

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 ...

2.10.12 Rebuilding or Repairing Tables or Indexes

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 ...

3.3.4.1 Selecting All Data

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 ...

5.5.3.2 Thread Pool Installation

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 ...

2.10.10 Upgrading MySQL with Directly-Downloaded RPM Packages

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 ...

11.2.4 The YEAR Type

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) ...