AUTO_INCREMENT  table option, insert a “dummy”  row with a value one less than the desired value after creating the table, and then delete the dummy row. 

For engines that support the AUTO_INCREMENT  table option in CREATE TABLE  statements, you can also use ALTER TABLE tbl_name  AUTO_INCREMENT = N  to reset the AUTO_INCREMENT  value. The value cannot be set lower than the maximum value currently in the column. 

• AVG_ROW_LENGTH 

An approximation of the average row length for your table. You need to set this only for large tables with variable-size rows. 

When you create a MyISAM  table, MySQL uses the product of the MAX_ROWS  and AVG_ROW_LENGTH options to decide how big the resulting table is. If you don’t specify either option, the maximum size for MyISAM  data and index files is 256TB by default. (If your operating system does not support files that large, table sizes are constrained by the file size limit.) If you want to keep down the pointer sizes to make the index smaller and faster and you don’t really need big files, you can decrease the default pointer size by setting the myisam_data_pointer_size  system variable. (See Section 5.1.8, “Server System Variables” .) If you want all your tables to be able to grow above the default limit and are willing to have your tables slightly slower and larger than necessary, you can increase the default pointer size by setting this variable. Setting the value to 7 permits table sizes up to 65,536TB. 

• [DEFAULT] CHARACTER SET 

Specifies a default character set for the table. CHARSET  is a synonym for CHARACTER SET . If the character set name is DEFAULT , the database character set is used. 

• CHECKSUM 

Set this to 1 if you want MySQL to maintain a live checksum for all rows (that is, a checksum that MySQL updates automatically as the table changes). This makes the table a little slower to update, but also makes it easier to find corrupted tables. The CHECKSUM TABLE  statement reports the checksum. ( MyISAM  only.) 

• [DEFAULT] COLLATE 

Specifies a default collation for the table. 

• COMMENT 

A comment for the table, up to 2048 characters long. 

You can set the InnoDB MERGE_THRESHOLD  value for a table using the table_option COMMENT clause. See Section 15.8.11, “Configuring the Merge Threshold for Index Pages” . 

Setting NDB_TABLE options. The table comment in a CREATE TABLE  that creates an NDB  table or an ALTER TABLE  statement which alters one can also be used to specify one to four of the NDB_TABLE options NOLOGGING , READ_BACKUP , PARTITION_BALANCE , or FULLY_REPLICATED  as a set of name- value pairs, separated by commas if need be, immediately following the string NDB_TABLE=  that begins the quoted comment text. An example statement using this syntax is shown here (emphasized text): 

CREATE TABLE t1 ( c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c2 VARCHAR(100), c3 VARCHAR(100) ) ENGINE=NDB 

