PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
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/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, ...An auto-updated column remains unchanged if all other columns are set to their current ...
https://dev.mysql.com/doc/refman/9.7/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. This phenomenon can lead to different results for a given TIMESTAMP ...
https://dev.mysql.com/doc/refman/9.7/en/datetime.html
MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 11.1.3, “Date and Time Literals”. The TIMESTAMP data type is used for values that contain both date and time parts. TIMESTAMP has a range of ...This ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-file-formats.html
<AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> <CONNECTION_ID>5</CONNECTION_ID> <STATUS>0</STATUS> <STATUS_CODE>0</STATUS_CODE> <USER>root[root] @ localhost ... Important ...
https://dev.mysql.com/doc/refman/9.7/en/server-system-variables.html
explicit_defaults_for_timestamp Command-Line Format --explicit-defaults-for-timestamp[={OFF|ON}] Deprecated Yes System Variable explicit_defaults_for_timestamp Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-conflict-resolution.html
Some types of conflict resolution supported by NDB Cluster (NDB$OLD(), NDB$MAX(), and NDB$MAX_DELETE_WIN(); NDB$MAX_INS() and NDB$MAX_DEL_WIN_INS()) implement this user-defined column as a “timestamp” column (although its type cannot be ...
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-functions.html
(For our purposes, a single query also includes a call to a stored program (stored routine, trigger, or event) and all subprograms called by that program.) This principle also applies to CURDATE(), CURTIME(), UTC_DATE(), UTC_TIME(), UTC_TIMESTAMP(), ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-file-reading.html
The component opens each remaining candidate file, verifies that the file actually contains JSON audit events, and sorts the files using the timestamps from the first event of each file. For example: [ { "timestamp": "2025-05-18 13:39:33", "id": 0, ... The audit log component supports functions that provide an SQL interface for reading audit log ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-file-reading.html
The plugin opens each remaining candidate file, verifies that the file actually contains JSON audit events, and sorts the files using the timestamps from the first event of each file. For example: [ { "timestamp": "2020-05-18 13:39:33", "id": 0, ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-logging-configuration.html
pwd_id format is pwd_timestamp-seq, where: pwd_timestamp is a UTC value in YYYYMMDDThhmmss format indicating when the password was created. Sequence numbers start at 1 and increase for passwords that have the same pwd_timestamp value. For the ...