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/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/8.0/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/8.0/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/8.0/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 ... The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
avoid_temporal_upgrade Command-Line Format --avoid-temporal-upgrade[={OFF|ON}] Deprecated Yes System Variable avoid_temporal_upgrade Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF This variable controls whether ALTER ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.0/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(); additionally, in NDB 8.0.30 and later, NDB$MAX_INS() and NDB$MAX_DEL_WIN_INS()) implement this user-defined column as a “timestamp” ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
DATE 'str' TIME 'str' TIMESTAMP 'str' MySQL recognizes but, unlike standard SQL, does not require the type keyword. The TIMESTAMP syntax produces a DATETIME value in MySQL because DATETIME has a range that more closely corresponds to the standard ...