https://dev.mysql.com/cast-functions.html
SELECT statement: mysql> CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE) AS c1; mysql> SHOW CREATE TABLE new_table\G *************************** 1. row *************************** Table: new_table Create Table: CREATE TABLE `new_table` ( ...
https://dev.mysql.com/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/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/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/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/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/constraint-invalid-data.html
MySQL permits you to store certain incorrect date values into DATE and DATETIME columns (such as '2000-02-31' or '2000-02-00'). In this case, when an application has not enabled strict SQL mode, it up to the application to validate the dates before ... By default, MySQL is forgiving of invalid or improper data values and coerces them to valid values for data ...
https://dev.mysql.com/group-replication-configuring-consistency-guarantees.html
RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts. Scenario 3 you want specific transactions in your workload to always read up-to-date data from the group, so that whenever that sensitive ... Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: before and after transaction ...
https://dev.mysql.com/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/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 ...
