PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
For example, a database like this could be used by a farmer to keep track of livestock, or by a veterinarian to keep track of patient records. For this reason, you should probably ask your MySQL administrator for permission to use a database of your ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/5.7/en/date-calculations.html
What if you want to know which animals have birthdays next month? For this type of calculation, year and day are irrelevant; you simply want to extract the month part of the birth column. MySQL provides several functions that you can use to perform ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
This is true even if the condition occurs in an inner block. This is relevant within the context of cursors and is used to control what happens when a cursor reaches the end of a data set. To detect this condition, you can set up a handler for it or ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...