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/replication-gtids-functions.html
CREATE FUNCTION GTID_INTERSECTION_WITH_UUID(gs LONGTEXT, uuid TEXT) RETURNS LONGTEXT RETURN GTID_SUBTRACT(gs, GTID_SUBTRACT_UUID(gs, uuid)) | Example 19.1 Verifying that a replica is up to date The built-in functions GTID_SUBSET() and ... This ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-tables.html
Given these considerations, the CREATE TABLE statement for the event table might look like this: mysql> CREATE TABLE event (name VARCHAR(20), date DATE, type VARCHAR(15), remark VARCHAR(255)); As with the pet table, it is easiest to load the initial ... The pet table keeps track of which pets you ...
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html
Any type coercion mandated by an expression that makes use of the return value is now performed following function execution. Examples: If you compare a DATETIME to two DATE values, convert the DATE values to DATETIME values. If you use a string ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
Pruning can also be applied for tables partitioned on a DATE or DATETIME column when the partitioning expression uses the YEAR() or TO_DAYS() function. Important Invalid DATE and DATETIME values referenced in the WHERE condition of a statement ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
For example, strict SQL mode can be enabled, or the mode can include values such as NO_ZERO_DATE or NO_ZERO_IN_DATE. An invalid value for a DATETIME, DATE, or TIME column is inserted as the implicit default value, regardless of the SQL mode ...The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-calendar.html
Monday Tuesday Wednesday Thursday Friday Saturday Sunday 1 2 3 4 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 There are no dates between October 4 and October 15. Any dates before the cutover are Julian, and any dates following the cutover are ... MySQL uses what is known as a proleptic Gregorian ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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 ...