What are the design specifications of mysql table

This article mainly introduces what are the design specifications of the mysql table. It is very detailed and has a certain reference value. Friends who are interested must read it!

1. The number of single instance tables must be controlled within 2000.

2. The number of sub-tables must be controlled within 1024.

3. The table must have a primary key. It is recommended to use UNSIGNED integers as the primary key.

Potential pit: delete the non-primary key table, if it is the master-slave schema of row mode, it will be hung in the library.

4. The use of foreign keys is prohibited. If integrity is to be guaranteed, it should be achieved through the application.

Example

Create table class (major varchar (16) comment 'professional', name char (8) comment 'class name', nums int comment 'number'); above is all the content of this article "what are the design specifications of mysql table". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!