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/no-matching-rows.html
In some cases, changing the FLOAT to a DOUBLE fixes this. If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether ...
https://dev.mysql.com/doc/refman/9.7/en/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. For example, INT(4) specifies an INT with a display width of four digits. This optional display ...
https://dev.mysql.com/doc/refman/9.7/en/numeric-types.html
The keyword INT is a synonym for INTEGER, and the keywords DEC and FIXED are synonyms for DECIMAL. These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, ...
https://dev.mysql.com/doc/refman/9.7/en/optimize-table.html
It does not work for fixed-width columns of in-memory tables, nor does it work for Disk Data tables. OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-queries-myisam.html
The only cases where splitting up a table makes an appreciable difference is if it is a MyISAM table using dynamic row format that you can change to a fixed row size, or if you very often need to scan the table but do not need most of the columns.
https://dev.mysql.com/doc/refman/9.7/en/order-by-optimization.html
There is an index on only a prefix of a column named in the ORDER BY clause. <sort_key, packed_additional_fields>: Like the previous variant, but the additional columns are packed tightly together instead of using a fixed-length encoding. This ...
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/out-of-range-and-overflow.html
When a floating-point or fixed-point column is assigned a value that exceeds the range implied by the specified (or default) precision and scale, MySQL stores the value representing the corresponding endpoint of that range. If no restrictive modes ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-storage-engines.html
The maximum amount of fixed-size data that can be stored per partition in an NDB table is 128 TB. In MySQL 9.7, partitioning support is not actually provided by the MySQL Server, but rather by a table storage engine's own or native partitioning ...