Mysql_ Some of my usage rules/tricks/conventions

Source: Internet
Author: User
Tags lowercase win32

1. Database name/table name/Field name parent case

  Database name/table name/field names using lowercase letters

1.1. Database name/table name case

Because Mysql-noinstall-5.1.73-win32.zip is not the same for database name/table name-case sensitive settings under Windows and Linux, the default letter case is not sensitive and the latter is case sensitive.

To avoid problems when the database migrates the operating system, the contract database name/table name parent is lowercase.

1.2. The field letter of the table is case-sensitive

Mysql-noinstall-5.1.73-win32.zip in Windows and Linux, letters are case sensitive.

However, just in case, also use the full lowercase letter way, unify to remember some.

Mysql_ Some of my usage rules/tricks/conventions

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.