PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
That is, for two numbers X1 and X2 that have scale S1 and S2, the scale of the result is S1 + S2: mysql> SELECT .01 * .01; +-----------+ | .01 * .01 | +-----------+ | 0.0001 | +-----------+ Example 3. This section provides some examples that show ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-expressions.html
Suppose that we have this statement: INSERT INTO t SET i = 1/0; This is what happens for combinations of strict and ERROR_FOR_DIVISION_BY_ZERO modes. With precision math, exact-value numbers are used as given whenever possible. For example, numbers ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-numbers.html
Exact-value numeric literals have an integer part or fractional part, or both. The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric literals.
https://dev.mysql.com/doc/refman/8.0/en/primary-key-optimization.html
If your table is big and important, but does not have an obvious column or set of columns to use as a primary key, you might create a separate column with auto-increment values to use as the primary key. The primary key for a table represents the ...
https://dev.mysql.com/doc/refman/8.0/en/program-options.html
Because later options take precedence over earlier ones, the processing order means that environment variables have the lowest precedence and command-line options the highest. There are several ways to specify options for MySQL programs: List the ...
https://dev.mysql.com/doc/refman/8.0/en/program-variables.html
Many MySQL programs have internal variables that can be set at runtime using the SET statement. See Section 15.7.6.1, “SET Syntax for Variable Assignment”, and Section 7.1.9, “Using System Variables”. Most of these program variables also ...
https://dev.mysql.com/doc/refman/8.0/en/programs-development.html
If you have a C or C++ program that handles multiply specified options this way but that doesn't read option files, you need add only two lines to give it that capability. This section describes some utilities that you may find useful when ...
https://dev.mysql.com/doc/refman/8.0/en/programs.html
Most programs have options that are specific to their own operation, but the option syntax is similar for all of them. This chapter provides a brief overview of the MySQL command-line programs provided by Oracle Corporation. It also discusses the ...
https://dev.mysql.com/doc/refman/8.0/en/purge-binary-logs.html
If you have an active replica that currently is reading one of the log files you are trying to delete, this statement does not delete the log file that is in use or any log files later than that one, but it deletes any earlier log files. PURGE { ...
https://dev.mysql.com/doc/refman/8.0/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 ...