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/features.html
For example: mysql> SELECT CONCAT(first_name, ' ', last_name) -> FROM citizen -> WHERE income/dependents > 10000 AND age > 30; Full support for SQL GROUP BY and ORDER BY clauses. Support for group functions (COUNT(), AVG(), STD(), SUM(), MAX(), ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier. With this modifier, certain characters have special meaning at the beginning or end of words in the search string. In the following query, the + and - operators ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-thread-pool-table-reference.html
Table 24.7 INFORMATION_SCHEMA Thread Pool Tables Table Name Description TP_THREAD_GROUP_STATE Thread pool thread group states TP_THREAD_GROUP_STATS Thread pool thread group statistics TP_THREAD_STATE Thread pool thread information .
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
References to columns in other tables, as long as the SELECT does not use GROUP BY. If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/5.7/en/installing-source-distribution.html
To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation Prerequisites”. Obtain a distribution file using the instructions in Section 2.1.3, ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
Notes The mysql user is created using the -r and -s /bin/false options of the useradd command, so that it does not have login permissions to your server host (see Creating the mysql User and Group for details). The recommended way to install MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/load-data-local-security.html
If you use LOAD DATA LOCAL in Perl scripts or other programs that read the [client] group from option files, you can add a local-infile option setting to that group. The LOAD DATA statement loads a data file into a table. The statement can load a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-binary.html
(You can obtain this name using ECHO %USERNAME% on the command line.) To install and run NDB Cluster executables as Windows services, this user should be a member of the Administrators group. You should also have the MySQL client (mysql.exe) on this ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-events.html
An event report reported in the event logs has the following format: datetime [string] severity -- message For example: 09:19:30 2005-07-24 [NDB] INFO -- Node 4 Start phase 4 completed This section discusses all reportable events, ordered by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node.html
Important Currently, you must add new data nodes to an NDB Cluster as part of a new node group. In addition, it is not possible to change the number of fragment replicas (or the number of nodes per node group) online. This section describes how to ...