PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/audit-log-logging-configuration.html
At this point, the plugin is still writing to the current log file, which has been renamed to audit.log.1. For pruning based on rotated log file age, the pruning point is the current time minus the value of audit_log_prune_seconds. The audit log ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-plugin.html
At this point, the group profile information is cached, including its name, membership, and allowlist. For example, if mysql is the firewall database: CALL mysql.sp_set_firewall_group_mode(group, mode); Firewall stored procedures are transactional; ... This section contains information about the MySQL Enterprise Firewall ...
https://dev.mysql.com/doc/refman/9.7/en/gis-class-linestring.html
A LineString is a Curve with linear interpolation between points. LineString Properties A LineString has coordinates of segments, defined by each consecutive pair of points. A LineString is a Line if it consists of exactly two points. LineString ...