mysql naming conventions

Naming conventions Description: Refers to the naming conventions of database objects such as tables (table), sequences (SEQUENCE), Procedures (PROCEDURE), triggers (TRIGGER), and so on. 1. Basic naming principles (1) Rule 1: Name the use of

Note: The main content of this article is referenced from Internet related articles1.MySQL Case Sensitive RulesIn MySQL, a library will correspond to a folder, the library of the table will be stored in the folder in the file, so the sensitivity of

First, "Operation Specification"1. If no notes, the first ID field in the table must be the primary key and automatically grow;2. If no note, the field of the numeric type use the unsigned property;3. If no notes, the Sort field order_id in the

First, "Operation Specification"1. If no notes, the first ID field in the table must be the primary key and automatically grow;2. If no note, the field of the numeric type use the unsigned property;3. If no notes, the Sort field order_id in the

MySQL database naming rules and conventions bitsCN.com I. [operational specifications]1. if there is no remark, the first id field in the table must be the primary key and automatically grow;2. if there is no remark, use the UNSIGNED attribute for

1, database name and table name are strictly case-sensitive;2, the table alias is strictly case-sensitive;3, the column name and the alias of the column in all cases are ignored case;4, variable names are also strictly case-sensitive;MySQL is case

Transferred from: http://www.cnblogs.com/conanwang/p/5927557.html1.MySQL Case Sensitive RulesIn MySQL, a library will correspond to a folder, the library of the table will be stored in the folder in the file, so the sensitivity of the operating

Do you have a headache in obtaining MYSQL database naming and designing specifications? If this is the case, the following articles will give you corresponding solutions. The following articles mainly introduce solutions for obtaining MYSQL database

MySQL case sensitivity and naming rules bitsCN.com MySQL case sensitivity and naming rules Note: For most of the content in this article, refer to relevant articles from the Internet 1. in MySQL, a database corresponds to a folder, and tables in the

Transferred from: http://blog.csdn.net/notbaron/article/details/50868485Welcome reprint, Reprint please indicate source: http://blog.csdn.net/notbaron/article/details/50868485All SQL basically uses identifiers to refer to a database or its