INSERT Statement matching the given partition set . For more information and examples, see Section 24.5, “Partition Selection” . tbl_name  is the table into which rows should be inserted. Specify the columns for which the statement provides values as follows: Column values can be given in several ways: If strict SQL mode is enabled, an  INSERT  statement generates an error if it does not specify an explicit value for every column that has no default value. See Section 5.1.11, “Server SQL Modes” . If strict mode is not enabled, MySQL uses the implicit default value for any column that has no explicitly defined default. If strict mode is enabled, an error occurs if any column has no default value. •Provide a parenthesized list of comma-separated column names following the table name. In this case, a value for each named column must be provided by the  VALUES  list,  VALUES ROW()  list, or  SELECT statement. For the  INSERT TABLE  form, the number of columns in the source table must match the number of columns to be inserted. •If you do not specify a list of column names for  INSERT ... VALUES  or  INSERT ... SELECT , values for every column in the table must be provided by the  VALUES  list,  SELECT  statement, or  TABLE statement. If you do not know the order of the columns in the table, use  DESCRIBE  tbl_name  to find out. •A  SET  clause indicates columns explicitly by name, together with the value to assign each one. •If strict SQL mode is not enabled, any column not explicitly given a value is set to its default (explicit or implicit) value. For example, if you specify a column list that does not name all the columns in the table, unnamed columns are set to their default values. Default value assignment is described in Section 11.6, “Data Type Default Values” . See also Section 1.7.3.3, “Enforced Constraints on Invalid Data” . •If both the column list and the  VALUES  list are empty,  INSERT  creates a row with each column set to its default value: •Use the keyword  DEFAULT  to set a column explicitly to its default value. This makes it easier to write INSERT  statements that assign values to all but a few columns, because it enables you to avoid writing an incomplete  VALUES  list that does not include a value for each column in the table. Otherwise, you must provide the list of column names corresponding to each value in the  VALUES  list. •If a generated column is inserted into explicitly, the only permitted value is  DEFAULT . For information about generated columns, see Section 13.1.20.8, “CREATE TABLE and Generated Columns” . •In expressions, you can use  DEFAULT( col_name )  to produce the default value for column  col_name . •Type conversion of an expression  expr  that provides a column value might occur if the expression data type does not match the column data type. Conversion of a given value can result in different inserted values depending on the column type. For example, inserting the string  ’1999.0e-2’  into an  INT , FLOAT ,  DECIMAL(10,6) , or  YEAR  column inserts the value  1999 ,  19.9921 ,  19.992100 , or  1999 , respectively. The value stored in the  INT  and  YEAR  columns is  1999  because the string-to-number conversion looks only at as much of the initial part of the string as may be considered a valid integer or year. For the  FLOAT  and  DECIMAL  columns, the string-to-number conversion considers the entire string a valid numeric value. •An expression  expr  can refer to any column that was set earlier in a value list. For example, you can do this because the value for  col2  refers to  col1 , which has previously been assigned: INSERT INTO  tbl_name  () VALUES(); 2632