1.MySQL does not distinguish the case of letters in the names of data columns, but does distinguish the names of databases and data tables. Therefore, at least when naming databases and data tables, you should experiment with uppercase and lowercase letters in an agreed-upon pattern.
2. The names of databases, data tables and data columns can be up to 64 characters long.
3. Avoid using special characters in names. MySQL allows you to try out all alphabetic and numeric characters, but different operating systems and different Linux distributions often use different default character sets. Modifying system settings such as the default character set often leads to some unpredictable consequences.
4. The names of data columns and data tables should be meaningful. As much as possible, column names should reflect their content and purpose as accurately as possible. For example, a name like authName is better than name.
5. Naming data columns according to a certain standard system can help reduce careless errors. It doesn't matter whether you prefer a name like author_name or a name like authorname. The key is that you should always maintain this style.
6.Similarly, a unified decision should be made on whether to use a singular noun or a clitic noun as a name. I never use plural nouns when naming data tables and data columns. There is no right or wrong here, but if half the names in the data table are singular nouns and the other half are plural nouns, I'm afraid you will become confused over time.