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/select.html
In this case, rows are selected only from the partitions listed, and any other partitions of the table are ignored. For example: SELECT id, * FROM t1 To avoid this problem, use a qualified tbl_name.* reference: SELECT id, t1.* FROM t1 Use qualified ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
This function does not work properly if the first argument contains a comma (,) character. (Multibyte characters therefore become more than two digits.) The inverse of this operation is performed by the UNHEX() function. mysql> SELECT ...For ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html
(This capability does not apply to log files written in other formats.) When the audit log plugin initializes and is configured for JSON logging, it uses the directory containing the current audit log file as the location to search for readable ...
https://dev.mysql.com/doc/refman/5.7/en/is-null-optimization.html
For example, MySQL can use indexes and ranges to search for NULL with IS NULL. This optimization does not occur in cases when the column might produce NULL anyway (for example, if it comes from a table on the right side of a LEFT JOIN). This ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
For example, to disable InnoDB mutex wait event instruments related to full-text search, add the following rule: performance-schema-instrument='wait/synch/mutex/innodb/fts%=OFF' Note Rules with a longer prefix such as wait/synch/mutex/innodb/fts% ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
The implication of this is that, at any given time, the replica is not guaranteed to be in synchrony with the source unless you take some special measures. (This is why TIMESTAMP is well replicated.) In the Time column in the output of SHOW ... In ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-legacy-filtering.html
Note This section describes legacy audit log filtering, which applies under either of these circumstances: Before MySQL 5.7.13, that is, prior to the introduction of rule-based audit log filtering described in Section 6.4.5.7, “Audit Log ...As of ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | PRECEDES } ...A ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html
MYSQL_RANDOM_ROOT_PASSWORD: When this variable is true (which is its default state, unless MYSQL_ROOT_PASSWORD is set or MYSQL_ALLOW_EMPTY_PASSWORD is set to true), a random password for the server's root user is generated when the Docker container ...A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Included binaries are limited to: /usr/bin/my_print_defaults /usr/bin/mysql /usr/bin/mysql_config /usr/bin/mysql_install_db /usr/bin/mysql_tzinfo_to_sql /usr/bin/mysql_upgrade /usr/bin/mysqladmin /usr/bin/mysqlcheck /usr/bin/mysqldump /usr/bin/mysqlpump /usr/sbin/mysqld All binaries are stripped; they contain no debug ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
This means that you can use the following SELECT statement to find rows into which invalid ENUM values were assigned: mysql> SELECT * FROM tbl_name WHERE enum_col=0; The index of the NULL value is NULL. For example, you can retrieve numeric values ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...