Some table options in MySQL

Source: Internet
Author: User

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 '


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:


Some table options in MySQL

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.