Some table options in MySQL

Table Options List

Table option is to create a table when the overall setting of the table, mainly the following:

charset = the character encoding to use,

Engine = The storage engine to be used (also called the table type),

Auto_increment = Sets the initial value of the self-growing field of the current table, default is 1

Comment = ' Some explanatory text of the table '

Description

1, the character encoding is set to be different from the database settings. If you do, you don't need to set it up: because it automatically uses database-level settings;

2,engine(storage engine) at the code level, is a noun:InnoDB, MyIsam, BDB, archive, memory. The default is InnoDB.

What is called a storage engine?

The storage engine is the "mechanism" for storing data to the hard disk . In fact, there are several mechanisms (as mentioned in the name above);

different storage engines, in fact, mainly from 2 large layers to design the storage mechanism:

1, speed as fast as possible;

2, as many functions as possible;

choosing a different storage engine is a "tradeoff" between the performance and functionality described above .

Broadly as follows:

Demonstrate:

Some table options in MySQL