PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored in the InnoDB data dictionary. If you move data files around, dictionary data can become inconsistent. If a data dictionary corruption or consistency issue prevents you from starting InnoDB, see Section ...
https://dev.mysql.com/doc/refman/9.7/en/numeric-type-syntax.html
For integer data types, M indicates the minimum display width. Display width is unrelated to the range of values a type can store, as described in Section 13.1.6, “Numeric Type Attributes”. For floating-point and fixed-point data types, M is ...
https://dev.mysql.com/doc/refman/9.7/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-session-info.html
For general information about stored routines in MySQL, see Section 27.2, “Using Stored Routines”. The MLE component provides a number of loadable functions for working with MLE user sessions. These functions are listed and described here: ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-columns.html
The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS partitioning enables the use of multiple columns in partitioning keys. All of these columns are taken into account both for the purpose ...
https://dev.mysql.com/doc/refman/9.7/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/9.7/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
https://dev.mysql.com/doc/refman/9.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. See Section 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/9.7/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). The keyword INT is a synonym for INTEGER, and the keywords DEC and FIXED ...