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/precision-math.html
MySQL provides support for precision math: numeric value handling that results in extremely accurate results and a high degree control over invalid values. These features have several implications for numeric operations and provide a high degree of ...Precision math is based on these two features: SQL modes that control how strict the server is about accepting or rejecting invalid ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variable-reference.html
Please see the corresponding item descriptions for details on setting and using the variables. The last column indicates whether the scope for each variable is Global, Session, or both. Where appropriate, direct links to further information about ...
https://dev.mysql.com/doc/refman/5.7/en/sql-transactional-statements.html
MySQL supports local transactions (within a given client session) through statements such as SET autocommit, START TRANSACTION, COMMIT, and ROLLBACK. XA transaction support enables MySQL to participate in distributed transactions as well.
https://dev.mysql.com/doc/refman/5.7/en/start-group-replication.html
If super_read_only=ON and the member should join as a primary, super_read_only is set to OFF once Group Replication successfully starts. A server that participates in a group in single-primary mode should use skip_replica_start=ON. Otherwise, the ...
https://dev.mysql.com/doc/refman/5.7/en/stop-group-replication.html
As soon as you issue STOP GROUP_REPLICATION the member is set to super_read_only=ON, which ensures that no writes can be made to the member while Group Replication stops. To be completely safe, ensure that your applications can no longer connect to ...Any other replication channels running on the member are also ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-errors.html
Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for statements where the subquery must return at most one row but returns multiple rows.
https://dev.mysql.com/doc/refman/5.7/en/subquery-restrictions.html
For example, this limitation applies to statements of the following forms: DELETE FROM t WHERE ... FROM t ...); Exception: The preceding prohibition does not apply if for the modified table you are using a derived table and that derived table is ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-path.html
Prior to MySQL 5.7.14, backslashes in Windows path names are converted to forward slashes in the result. Example mysql> SELECT sys.format_path('/usr/local/mysql/data/world/City.ibd'); +---------------------------------------------------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-truncate-all-tables.html
Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Example mysql> CALL ...
https://dev.mysql.com/doc/refman/5.7/en/table-corruption.html
If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or 'crashed'. If you get a lot of these errors, without mysqld ...If this happens, MySQL writes an entry in the hostname.err file 'Warning: Checking table ...' which is followed by Warning: Repairing table if the table needs to be ...