PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/blob.html
This means that, if the index requires unique values, duplicate-key errors occur for values that differ only in the number of trailing spaces. This is in contrast to all other data types, for which storage is allocated once per column when the table ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/5.7/en/char.html
This means that all CHAR, VARCHAR, and TEXT values are compared without regard to any trailing spaces. “Comparison” in this context does not include the LIKE pattern-matching operator, for which trailing spaces are significant. The CHAR and ...
https://dev.mysql.com/doc/refman/5.7/en/character-arrays.html
In some cases, this is the same as the <upper> array, which means that sorting is case-insensitive. Each simple character set has a configuration file located in the sql/share/charsets directory. For a character set named MYSYS, the file is named ...
https://dev.mysql.com/doc/refman/5.7/en/charset-general.html
The simplest way to do this is to look at the encodings: 0 for A and 1 for B. The collation is a set of rules (only one rule in this case): “compare the encodings.” We call this simplest of all possible collations a binary collation. A ...
https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
This can be done in several ways: Set the LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN environment variable to a value that begins with 1, Y, or y. A client-side authentication plugin is available that enables clients to send passwords to the server as ...
https://dev.mysql.com/doc/refman/5.7/en/communication-errors.html
If the log_error_verbosity system variable is set to 3, you might find messages like this in your error log: [Note] Aborted connection 854 to db: 'employees' user: 'josh' If a client is unable even to connect, the server increments the ... If ...
https://dev.mysql.com/doc/refman/5.7/en/condition-handling-restrictions.html
For example, this statement is invalid: PREPARE stmt1 FROM 'SIGNAL SQLSTATE "02000"'; SQLSTATE values in class '04' are not treated specially. In MySQL, this is not guaranteed, so to get the main error, you cannot do this: GET DIAGNOSTICS CONDITION ... SIGNAL, RESIGNAL, and GET DIAGNOSTICS are not permissible as prepared ...
https://dev.mysql.com/doc/refman/5.7/en/connection-interfaces.html
This section describes aspects of how the MySQL server manages client connections. In this connection thread model, there are as many threads as there are clients currently connected, which has some disadvantages when server workload must scale to ...Network Interfaces and Connection Manager Threads Client Connection Thread Management Connection Volume Management Network Interfaces and Connection Manager Threads The server is capable of listening for client connections on multiple network ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
This can be called the pet table, and it should contain, as a bare minimum, each animal's name. MySQL provides functions for doing date arithmetic, so this is not difficult. You want a table that contains a record for each of your pets. Because the ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. For nontransactional tables, an error occurs, but if this happens for the second or subsequent row of a ... Data ...