The implicit default value is tables for which there are foreign key constraints, the My SQL optimizer might process tables in an order that differs from that of their parent/child relationship. Instead, update a single table and rely on the provides to cause the other tables to be modified accordingly. COLUMN2 IS NULLAn outerjoin is performed based on the equijoin condition.
See Section 15.8.7, “Inno DB and FOREIGN KEY Constraints”. Records not matching the equijoin from table2 are marked with null.
Year values in the range 70-99 are converted to 1970-1999.
For YEAR, the rules are the same, with this exception: A numeric 00 inserted into YEAR(4) results in 0000 rather than 2000.
This option takes a list of one or more partitions or subpartitions (or both).