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/information-schema-statistics-table.html
CARDINALITY is counted based on statistics stored as integers, so the value is not necessarily exact even for small tables. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
On the other hand, tables containing mostly binary data (integers or floating point numbers) or data that is previously compressed (for example JPEG or PNG images) may not generally compress well, significantly or at all. Most often, the internal ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
Your application code can ensure referential integrity throughout this sequence of operations. For another example, consider an integer counter field in a table CHILD_CODES, used to assign a unique identifier to each child added to table CHILD. If ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
The value stored in the INT and YEAR columns is 1999 because the string-to-number conversion looks only at as much of the initial part of the string as may be considered a valid integer or year. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
Two scalar values are comparable if they have the same JSON_TYPE() types, with the exception that values of types INTEGER and DECIMAL are also comparable to each other. The functions in this section perform search or comparison operations on JSON ...
https://dev.mysql.com/doc/refman/8.0/en/json-table-functions.html
Saving an object or array triggers the optional on error clause; this also occurs when an error takes place during coercion from the value saved as JSON to the table column, such as trying to save the string 'asd' to an integer column. This section ...
https://dev.mysql.com/doc/refman/8.0/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/refman/8.0/en/key-space.html
Numbers are stored with the high byte first, so this helps when you have many integer keys that have an identical prefix. You can roughly calculate the size for the index file as (key_length+4)/0.67, summed over all keys. This is for the worst case ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
The only requirements for binary portability are that the machine uses two's-complement signed integers and IEEE floating-point format. MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table ...