PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions-and-modifiers.html
They are often used with a GROUP BY clause to group values into subsets.
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
For the Group Replication applier channel (group_replication_applier), which only has an SQL thread and no I/O thread, this is the case if the SQL thread is stopped, but with that channel you cannot use the RELAY_LOG_FILE and RELAY_LOG_POS options.
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
In addition, the user making the connection must be a member of the Windows group specified by the named_pipe_full_access_group system variable. In addition, the user making the connection must be a member of the Windows group specified by the ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
Before downgrading from MySQL 5.7, review the information in this section. System Table Changes InnoDB Changes Logging Changes SQL Changes System Table Changes In MySQL 5.7.13, system table columns that store user@host string values were increased ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
This is useful when you want to put data into ordered groups. You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
Is it possible to group stored procedures or stored functions into packages? A.4.9. Is it possible to group stored procedures or stored functions into packages? No. Where can I find documentation for MySQL stored procedures and stored functions? ...
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 ...