PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
Table 12.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/5.7/en/concurrent-inserts.html
In addition, for those statements a read lock is placed on the selected-from table such that inserts into that table are blocked. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/conditions-and-parameters.html
If an exception is handled by a CONTINUE or EXIT handler that contains a RESIGNAL statement, execution of RESIGNAL pops the Diagnostics Area stack, thus signalling the exception (that is, the information that existed before entry into the handler).
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-installation.html
Determination of the applicable user name and host name takes proxying into account and occurs as follows: If the client user proxies another user, the account for failed-connection counting is the proxying user, not the proxied user. This section ...
https://dev.mysql.com/doc/refman/5.7/en/connectors-apis.html
libmysqld is an embedded MySQL server library that enables you to embed an instance of the MySQL server into your C applications. MySQL Connectors provide connectivity to the MySQL server for client programs. APIs provide low-level access to MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html
Unless strict mode is disabled (not recommended, but see Section 5.1.10, “Server SQL Modes”), the definition of a ENUM or SET column acts as a constraint on values entered into the column. ENUM and SET columns provide an efficient way to define ...
https://dev.mysql.com/doc/refman/5.7/en/controlling-query-plan-evaluation.html
The optimizer_search_depth variable tells how far into the “future” of each incomplete plan the optimizer should look to evaluate whether it should be expanded further. The task of the query optimizer is to find an optimal plan for executing an ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte character set. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
SELECT, if IF NOT EXISTS is given and the target table exists, nothing is inserted into the destination table, and the statement is not logged. You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/creating-rsa-files-using-openssl.html
To create the RSA private and public key-pair files, run these commands while logged into the system account used to run the MySQL server so the files are owned by that account: openssl genrsa -out private_key.pem 2048 openssl rsa -in ... This ...