What are the naming conventions in mysql

This article mainly talks about "what are the naming conventions in mysql". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what are the naming conventions in mysql"?

1. The library name and the application name are the same as possible.

2. Table name, field name must be in lowercase letters or numbers.

The beginning of a number is prohibited, and only a number appears between two underscores.

The library name, table name and column name must be well-known and must not exceed 32 characters in length.

3. The retention word is prohibited.

Such as desc, range, match, delayed and so on.

4. Library backups must be prefixed with bak and suffixed with date.

Example

Note: MySQL is not case-sensitive under Windows, but it is case-sensitive by default under Linux. Therefore, database names, table names, and field names are not allowed to appear in uppercase letters. Positive examples: `AliyunAdmin`, `rdc_ config`, `level3_ name` counterexamples: `AliyunAdmin`, `rdcConfig`, `level_3_ name`. I believe that if you have a better understanding of "what are the naming conventions in mysql", you might as well do it in practice! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!