PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-migration.html
In conjunction with the MySQL binary log, you can perform point-in-time recovery. InnoDB data and log files are binary-compatible on all platforms having the same floating-point number format. If the floating-point formats differ but you have not ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
If D is 0, the result has no decimal point or fractional part. The optional third parameter enables a locale to be specified to be used for the result number's decimal point, thousands separator, and grouping between separators. For functions that ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
For example, adding a very small floating-point value to a very large value causes the very small value to be “hidden” by the large value. Loss of precision due to inverse aggregation is a factor only for operations on floating-point ... Window ...
https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html
The binary log files provide you with the information you need to replicate changes to the database that are made subsequent to the point at which you performed a backup. Therefore, to allow a server to be restored to a point-in-time, binary logging ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
AUTO_INCREMENT An integer or floating-point column can have the additional attribute AUTO_INCREMENT. (See Section 7.1.8, “Server System Variables”.) If you want all your tables to be able to grow above the default limit and are willing to have ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
Implicit defaults are defined as follows: For numeric types, the default is 0, with the exception that for integer or floating-point types declared with the AUTO_INCREMENT attribute, the default is the next value in the sequence. Data type ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
1 row in set (0.00 sec) The only delimiter recognized between a date and time part and a fractional seconds part is the decimal point. The fractional part should always be separated from the rest of the time by a decimal point; no other fractional ... Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...
https://dev.mysql.com/doc/refman/8.0/en/entering-queries.html
At this point, it is more important to find out a little about how to issue queries than to jump right in creating tables, loading data into them, and retrieving data from them. (Do you see the error in the statement? The string 'Smith is missing ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html
Asynchronous replication can work only if the replica is able to continue reading the binary log from the point where it last read events. At that point, the replica is in synchrony with the source and the statement returns. In theory, by using a ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
The remote table that a FEDERATED table points to must exist before you try to access the table through the FEDERATED table. It is possible for one FEDERATED table to point to another, but you must be careful not to create a loop. The following ...