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/mysqlbinlog-backup.html
This enables you to examine events within the files more easily and to re-execute them (for example, by using the output as input to mysql). The second names only the first file and uses --to-last-log to read through the last. A difference between ... By default, mysqlbinlog reads binary log files and displays their contents in text ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
Examples: If you compare a DATETIME to two DATE values, convert the DATE values to DATETIME values. For DATE and DATETIME columns that are declared as NOT NULL, you can find the special date '0000-00-00' by using a statement like this: SELECT * FROM ... 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/windows-install-archive.html
Users who are installing from the noinstall package can use the instructions in this section to manually install MySQL.
https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html
Note MySQL Installer enables you to perform this and the next step (Install the X Plugin) at the same time for new installations on Microsoft Windows. If the upgrade is not run, X Plugin fails to start with the error message There was an error when ... To use MySQL 5.7 as a document store, the X Plugin needs to be ...
https://dev.mysql.com/doc/refman/5.7/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha2user -p Enter password: password For this connection attempt by sha2user, the server determines that caching_sha2_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math.html
These features have several implications for numeric operations and provide a high degree of compliance with standard SQL: Precise calculations: For exact-value numbers, calculations do not introduce floating-point errors. For example, MySQL treats ... MySQL provides support for precision math: numeric value handling that results in extremely accurate results and a high degree control over invalid ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
Maximum and minimum word length values are configurable using the innodb_ft_max_token_size and innodb_ft_min_token_size variables. The stopword list is loaded and searched for full-text queries using the server character set and collation (the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup-recovery.html
For information about point-in-time recovery, recovery from disk failure or corruption, and how InnoDB performs crash recovery, see Section 14.19.2, “InnoDB Recovery”. This section covers topics related to InnoDB backup and recovery. For ...
https://dev.mysql.com/doc/refman/5.7/en/binlog.html
This statement can execute only format description events and row events. It is generated by the mysqlbinlog program as the printable representation of certain events in binary log files. (See Section 4.6.7, “mysqlbinlog — Utility for Processing ...