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/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
If the actual data dictionary version is lower than the current expected version, the server creates data dictionary tables with updated definitions, copies persisted metadata to the new tables, atomically replaces the old tables with the new ones, ... 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 ...
https://dev.mysql.com/doc/refman/9.7/en/flow-control-functions.html
If all types are temporal, the result is temporal: If all temporal types are DATE, TIME, or TIMESTAMP, the result is DATE, TIME, or TIMESTAMP, respectively. Otherwise, for a mix of temporal types, the result is DATETIME. The second syntax returns ...