Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-column.html
The NDB API provides access to time types with microseconds (TIME, DATETIME, and TIMESTAMP) as Time2, Datetime2, and Timestamp2. (Time, Datetime, and Timestamp are deprecated as of the same version.) Use setPrecision() to set up to 6 fractional ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load-overview.html
To do this, specify the appropriate external table option (EXTERNAL_FORMAT, DATE FORMAT, DATETIME FORMAT, and TIME FORMAT for SQL syntax, and date_format, time_format, timestamp_format, and datetime_format (as of MySQL 9.5.1) for JSON syntax) and ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-dbsystem-details.html
UPDATING: The DB System is in the process of being updated. Last Updated: The date and time the DB System was last updated. Maintenance Window: When updates are available, they are initiated during the maintenance window, which is a two-hour period ... MySQL DB System Details 3.5.1 MySQL DB System Details The MySQL DB System Details page has the following ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-type-conversions.html
If set to true (the default), then the returned object is of type java.sql.Date. MySQL Connector/J is flexible in the way it handles conversions between MySQL data types and Java data types. In general, any MySQL data type can be converted to a ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
The timestamp is a UTC value in YYYY-MM-DDThh:mm:ss format indicating the date and time when the audit log plugin opened the file. Example: <RECORD_ID>12_2019-10-03T14:06:33</RECORD_ID> <TIMESTAMP> A string representing a UTC value in ... The MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
If the NO_ZERO_DATE or NO_ZERO_IN_DATE SQL mode is enabled and a date-valued default is not correct according to that mode, CREATE TABLE produces a warning if strict SQL mode is not enabled and an error if strict mode is enabled. For example, with ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
If related data is being updated across multiple tables, queries see either all old values or all new values, not a mix of old and new values. atomic DDL An atomic DDL statement is one that combines the data dictionary updates, storage engine ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
You should also keep in mind that this expression is evaluated each time a row is inserted or updated (or possibly deleted); this means that very complex expressions may give rise to performance issues, particularly when performing operations (such ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
Time zone offsets are also supported for inserted datetime values; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”, for more information. The session time zone setting does not affect values displayed by functions such as ... This ...