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/point-in-time-recovery-binlog.html
If your binary log contains \0 (null) characters, that output cannot be parsed by mysql unless you invoke it with the --binary-mode option. This section explains the general idea of using the binary log to perform a point-in-time-recovery. The next ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math.html
Similarly, you can treat division by zero as an error rather than as an operation that produces a result of NULL. MySQL provides support for precision math: numeric value handling that results in extremely accurate results and a high degree control ...
https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html
This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character sets. For example, an error in a collation might have been corrected, necessitating a table ...
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
Sometimes there are other ways to test membership in a set of values than by using a subquery. Also, on some occasions, it is not only possible to rewrite a query without a subquery, but it can be more efficient to make use of some of these ...
https://dev.mysql.com/doc/refman/5.7/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns. Partitioning is not supported for tables using the CSV storage engine.
https://dev.mysql.com/doc/refman/5.7/en/show-create-trigger.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers created in MySQL 5.7.2 or later, NULL for triggers created prior to 5.7.2. SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/show-engines.html
row *************************** Engine: BLACKHOLE Support: YES Comment: /dev/null storage engine (anything you write to it disappears) Transactions: NO XA: NO Savepoints: NO *************************** 5. SHOW [STORAGE] ENGINES SHOW ENGINES ...
https://dev.mysql.com/doc/refman/5.7/en/show-profile.html
For values that depend on the getrusage() system call, NULL is returned on systems such as Windows that do not support the call. Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release.
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers created in MySQL 5.7.2 or later, NULL for triggers created prior to 5.7.2. SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS ...
https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html
Columns that are part of a PRIMARY KEY are made NOT NULL even if not declared that way. In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, ...