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/compressed-format.html
Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables take very little disk space. This minimizes disk usage, which is helpful when using ...
https://dev.mysql.com/doc/refman/9.7/en/constant-folding-optimization.html
row *************************** Level: Note Code: 1003 Message: /* select#1 */ select `test`.`t`.`ti` AS `ti` from `test`.`t` where (`test`.`t`.`ti` = 255) 1 row in set (0.00 sec) Floating- or fixed-point value. Comparisons between constants and ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-foreign-keys.html
The size and sign of fixed precision types such as INTEGER and DECIMAL must be the same. Consequently, BLOB and TEXT columns cannot be included in a foreign key because indexes on those columns must always include a prefix length. MySQL supports ...
https://dev.mysql.com/doc/refman/9.7/en/creating-tables.html
Instead, it is better to store a fixed value such as date of birth. You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the name by ...
https://dev.mysql.com/doc/refman/9.7/en/downgrading.html
Monthly Rapid Updates (MRUs) and hot fixes also count as releases in this documentation. Notes Make sure you understand the MySQL release model for MySQL long-term support (LTS) and Innovation releases before proceeding with a downgrade. A ...
https://dev.mysql.com/doc/refman/9.7/en/examples.html
Supposing that each trader has a single fixed price per article, then (article, dealer) is a primary key for the records. Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price ...
https://dev.mysql.com/doc/refman/9.7/en/explain-output.html
ref is used if the join uses only a leftmost prefix of the key or if the key is not a PRIMARY KEY or UNIQUE index (in other words, if the join cannot select a single row based on the key value). To fix this disparity between column lengths, use ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-thread-pool.html
Unlike the default connection handling of the MySQL Server, the Thread Pool separates connections and threads, so there is no fixed relationship between connections and the threads that execute statements received from those connections. What is the ...
https://dev.mysql.com/doc/refman/9.7/en/features.html
An index may use a prefix of a column for CHAR, VARCHAR, BLOB, or TEXT column types. This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL. For ...
https://dev.mysql.com/doc/refman/9.7/en/function-optimization.html
A function is nondeterministic if, given fixed values for its arguments, it can return different results for different invocations. If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when ...