PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/precision-math-decimal-characteristics.html
This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range ...The ranges of values for the arguments are as follows: M is the maximum number of digits (the ...
https://dev.mysql.com/doc/refman/8.0/en/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. If any errors occur during a RENAME TABLE, the statement fails and no changes are made. Regardless of the statement used, if the ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table-optimization.html
However, changing the global key buffer size invalidates the buffer, causing increased disk I/O and slowdown for other sessions. REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance ...
https://dev.mysql.com/doc/refman/8.0/en/replication-compatibility.html
For example, you can replicate from a source running MySQL 5.6 to a replica running MySQL 5.7, from a source running MySQL 5.7 to a replica running MySQL 8.0, and so on. For example, if you are using a chained or circular replication setup, you ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-errors.html
For nontransactional storage engines such as MyISAM, it is possible to have a statement that only partially updates a table and returns an error code. If a statement produces the same error (identical error code) on both the source and the replica, ...This includes the case that a statement produces an error on the source or the replica, but not ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation-prerequisites.html
Some of these tools are needed no matter whether you use a standard source distribution or a development source tree. (MySQL binaries built on recent versions of Windows can generally be run on older versions.) You can determine the Windows version ...To install MySQL from source, the following system requirements must be satisfied, regardless of installation method: CMake, which is used as the build framework on all ...
https://dev.mysql.com/doc/refman/8.0/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. is the outer query (or outer statement), and (SELECT column1 FROM t2) is the subquery. We say that the subquery is ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
Semijoins are not applicable to window function optimization because semijoins apply to subqueries in WHERE and JOIN ... The workaround is to define the window in a WINDOW clause and refer to the window name in the OVER clauses. For faster ...
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
This is displayed as a DATETIME value, and is NULL if no start date and time are defined for the event. Time zone The event time zone, which is the time zone used for scheduling the event and that is in effect within the event as it executes. row ...
https://dev.mysql.com/doc/refman/8.0/en/nested-loop-joins.html
Nested-Loop Join Algorithm Block Nested-Loop Join Algorithm Nested-Loop Join Algorithm A simple nested-loop join (NLJ) algorithm reads rows from the first table in a loop one at a time, passing each row to a nested loop that processes the next table ... MySQL executes joins between tables using a nested-loop algorithm or variations on ...