Shulou(Shulou.com)05/31 Report--

Most people don't understand the knowledge points of this article "what is the design specification of mysql table", so Xiaobian summarizes the following contents for everyone. The contents are detailed, the steps are clear, and they have certain reference value. I hope everyone can gain something after reading this article. Let's take a look at this article "what is the design specification of mysql table".

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

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

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

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

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

examples

create table class( major varchar(16) comment 'professional', char name (8) comment 'class name', nums int comment 'number'); The above is the content of this article about "what is the design specification of mysql table". I believe everyone has a certain understanding. I hope the content shared by Xiaobian will help everyone. If you want to know more relevant knowledge content, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.