PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/numeric-types.html
These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION). For information about storage requirements of the numeric data types, see ...The keyword INT is a synonym for INTEGER, and the keywords DEC and FIXED are synonyms for ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html
Display width is unrelated to the range of values a type can store, as described in Section 13.1.6, “Numeric Type Attributes”. If you specify ZEROFILL for a numeric column, MySQL automatically adds the UNSIGNED attribute to the column. As of ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
As of MySQL 8.0.17, the ZEROFILL attribute is deprecated for numeric data types, as is the display width attribute for integer data types. An unsigned type can be used to permit only nonnegative numbers in a column or when you need a larger upper ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-numeric.html
For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string columns. Since large numeric values can be stored in fewer bytes than the corresponding strings, it is faster and takes less ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-functions.html
Table 14.8 Numeric Functions and Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator ABS() Return the absolute value ACOS() Return ...
https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html
Numeric evaluation occurs otherwise, with argument conversion to unsigned 64-bit integers as necessary. Numeric evaluation occurs otherwise, with argument conversion to unsigned 64-bit integers as necessary. Numeric evaluation occurs otherwise, with ... Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit functions and operators: | Bitwise ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-numbers.html
The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric literals. Approximate-value data types and numeric literals are handled as floating-point numbers. For ...
https://dev.mysql.com/doc/refman/8.0/en/fixed-point-types.html
The DECIMAL and NUMERIC types store exact numeric data values. In MySQL, NUMERIC is implemented as DECIMAL, so the following remarks about DECIMAL apply equally to NUMERIC. These types are used when it is important to preserve exact precision, for ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
ReservedConcurrentIndexOperations Version (or later) NDB 8.0.16 Type or units numeric Default 0 Range 0 - 4294967039 (0xFFFFFEFF) Added NDB 8.0.16 Restart Type Node Restart: Requires a rolling restart of the cluster. ReservedConcurrentOperations ...
https://dev.mysql.com/doc/refman/8.0/en/number-literals.html
Exact-value numeric literals have an integer part or fractional part, or both. Approximate-value numeric literals are represented in scientific notation with a mantissa and exponent. In MySQL, the DECIMAL type has several synonyms: NUMERIC, DEC, ...