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/show-table-status.html
For example, InnoDB stores multiple tables in its system tablespace and the data file timestamp does not apply. For MyISAM, the data file timestamp is used; however, on Windows the timestamp is not updated by updates, so the value is inaccurate.
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
See Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. For date and time types other than TIMESTAMP, the default is the appropriate “zero” value for the type. This is also true for TIMESTAMP if the ... Data ...
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-types.html
The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. The TIMESTAMP and DATETIME types have special automatic updating behavior, described in Section 13.2.5, “Automatic Initialization and ...
https://dev.mysql.com/doc/refman/9.7/en/fractional-seconds.html
MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...For ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-tables-table.html
For MyISAM, the data file timestamp is used; however, on Windows the timestamp is not updated by updates, so the value is inaccurate. UPDATE_TIME displays a timestamp value for the last UPDATE, INSERT, or DELETE performed on InnoDB tables that are ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/refman/9.7/en/mysqld-safe.html
--mysqld-safe-log-timestamps Command-Line Format --mysqld-safe-log-timestamps=type Type Enumeration Default Value utc Valid Values systemhyphenlegacy This option controls the format for timestamps in log output produced by mysqld_safe. UTC, utc ISO ... mysqld_safe is the recommended way to start a mysqld server on ...
https://dev.mysql.com/doc/refman/9.7/en/cast-functions.html
CAST(expr AS type [ARRAY]) CAST(timestamp_value AT TIME ZONE timezone_specifier AS DATETIME[(precision)]) timezone_specifier: [INTERVAL] '+00:00' | 'UTC' With CAST(expr AS type syntax, the CAST() function takes an expression of any type and produces ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...
https://dev.mysql.com/doc/refman/9.7/en/error-log-format.html
The ts (timestamp) key is unique to the JSON-format log sink. Early-Startup Logging Output Format The server generates some error log messages before startup options have been processed, and thus before it knows error log settings such as the ...
https://dev.mysql.com/doc/refman/9.7/en/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-restore.html
--timestamp-printouts Command-Line Format --timestamp-printouts{=true|false} Type Boolean Default Value true Causes info, error, and debug log messages to be prefixed with timestamps. The NDB Cluster restoration program is implemented as a separate ...