https://dev.mysql.com/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/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/documenters-translators.html
And a lot of spelling/language fixes for the FAQ (that turned into the MySQL manual a long time ago). The following people have helped us with writing the MySQL documentation and translating the documentation or error messages in MySQL. Paul DuBois ...
https://dev.mysql.com/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/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/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/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. Tested ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/group-replication-configuring-instances.html
For example, if each server instance is on a different machine with a fixed network address, you could use the IP address of the machine, such as 10.0.0.1. This section explains the configuration settings required for MySQL Server instances that ...
https://dev.mysql.com/group-replication-group-membership.html
Ultimately, this means that the administrator needs to step in and fix this. In MySQL Group Replication, a set of servers forms a replication group. A group has a name, which takes the form of a UUID. The group is dynamic and servers can leave ...
