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/thread-pool-installation.html
This section describes how to install MySQL Enterprise Thread Pool. For general information about installing plugins, see Section 5.5.1, “Installing and Uninstalling Plugins”. To be usable by the server, the plugin library file must be located ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key files. This section provides general guidance about configuring the server and clients for encrypted ...
https://dev.mysql.com/doc/refman/5.7/en/arithmetic-functions.html
(See Section 11.1, “Numeric Data Types”.) / Division: mysql> SELECT 3/5; -> 0.60 Division by zero produces a NULL result: mysql> SELECT 102/(1-1); -> NULL A division is calculated with BIGINT arithmetic only if performed in a context where its ... Table 12.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator DIV Integer division The usual arithmetic operators are ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
The following list describes the permitted predefined functions for function items: audit_log_exclude_accounts_is_null() Checks whether the audit_log_exclude_accounts system variable is NULL. For information about using JSON data in MySQL, see ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
To tell the server to perform no conversion of result sets or error messages, set character_set_results to NULL or binary: SET character_set_results = NULL; SET character_set_results = binary; For more information about character sets and error ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
The available referential actions are RESTRICT (the default), CASCADE, SET NULL, and NO ACTION. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL supports ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. The CSV storage engine is always compiled into the MySQL server. To examine the source for the CSV engine, look in the storage/csv directory of a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
MySQL permits you to store a “zero” value of '0000-00-00' as a “dummy date.” In some cases, this is more convenient than using NULL values, and uses less data and index space. “Zero” date or time values used through Connector/ODBC are ...
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause or a LEFT JOIN.
https://dev.mysql.com/doc/refman/5.7/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). The following discussion uses ...