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/begin-end.html
In the mysql command-line client, this is handled with the delimiter command. This means that no transactional savepoint is set at the start of the instruction block and the BEGIN clause used in this context has no effect on the current transaction.
https://dev.mysql.com/doc/refman/5.7/en/binary-log-formats.html
You can cause this format to be used by starting the server with --binlog-format=STATEMENT. This helps to eliminate issues when replicating certain statements between a source and replica which are using different storage engines. If MySQL cannot ...
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 ...