Ali Java Development Manual learn 3 MySQL protocol

Establishment of the table of norms

1. The expression is the concept of the field, must be named using IS_XXX, the data type is unsigned tinyint (1 means yes, 0 means no).

2. Table names do not use plural nouns.

3. Disable reserved words.

4. Decimal type, the use of float and double is forbidden.

5. The name of the table is best added to the "Business noun _ table role".

6. Update Field comments when modifying fields.

7. The field allows for proper redundancy to improve performance.

8. The Sub-database table is considered when the number of single-table rows exceeds 5 million lines or if the single table exceeds 2G.

9. Suitable character storage length, not only save the database table space, save the index storage, more importantly, improve the retrieval speed.

Ali Java Development Manual learn 3 MySQL protocol