PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/9.7/en/server-options.html
--sql-mode=value[,value[,value...]] Command-Line Format --sql-mode=name System Variable sql_mode Scope Global, Session Dynamic Yes SET_VAR Hint Applies Yes Type Set Default Value ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES NO_ZERO_IN_DATE NO_ZERO_DATE ...
https://dev.mysql.com/doc/refman/9.7/en/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current timestamp). For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, ...If both are present in a column definition, either can occur ...
https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html
If one of the arguments is a TIMESTAMP or DATETIME column and the other argument is a constant, the constant is converted to a timestamp before the comparison is performed. To be safe, always use complete datetime, date, or time strings when doing ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/9.7/en/upgrading-what-is-upgraded.html
For an update-qualified release, the server version used by the upgrade process remains the three-part MAJOR.MINOR.PATCH compatibility identity. The fourth update component is descriptive and does not cause a data dictionary or server upgrade, alter ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/9.7/en/arithmetic-functions.html
For example, to add date values, use DATE_ADD(); see Section 14.7, “Date and Time Functions”. Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-file-formats.html
Table 8.46 Audit Log Class and Event Combinations Class Value Permitted Event Values audit startup, shutdown connection connect, change_user, disconnect general status table_access_data read, delete, insert, update connection_data Information about ... The MySQL server calls the audit log component to write an audit record to its log file whenever an auditable event ...
https://dev.mysql.com/doc/refman/9.7/en/binary-log.html
The binary log also contains information about how long each statement took that updated data. These events bring databases up to date from the point of the backup. If you disable binary logging, either omit these options, or specify ... The binary ...
https://dev.mysql.com/doc/refman/9.7/en/check-table.html
Table is already up to date means that the storage engine for the table indicated that there was no need to check the table. A table is reported as needing a rebuild if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and ...
https://dev.mysql.com/doc/refman/9.7/en/create-tablespace.html
The precise syntax and semantics depend on the storage engine used. MySQL NDB Cluster also supports tablespaces using the NDB storage engine. Considerations for InnoDB Considerations for NDB Cluster Options Notes InnoDB Examples NDB Example ...