Shulou(Shulou.com)06/03 Report--

The purpose of this article is to share with you what grammar specifications mysql has. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1. The sql syntax of mysql is not case-sensitive.

2. try to use 26 English letters in uppercase and lowercase, the number 0-9, and underscore when naming.

Do not use other symbols.

3. It is recommended that you do not use mysql keywords as table names, field names, etc.

If you use it carelessly, use `(float sign) in the SQL statement.

4. There should be no spaces between the database and object names such as table names and field names.

In the same mysql software, the database cannot have the same name. Tables cannot have the same name in the same library, and fields cannot have the same name in the same table.

Example

# the following two sentences are the same, case-insensitive show databases;SHOW DATABASES; # create table # create table student info (...); # the table name is incorrect because there is a space create table student_info (...) in the table name; # where name uses ``drift because name and predefined identifiers such as system keywords or system function names are duplicated. CREATE TABLE t_stu (id INT, `name` VARCHAR (20)); select id as "number", `name` as "name" from tweak stub; # when aliasing, as can omit select id as number, `name` as name from tstub; # if there is no space in the field alias, you can omit "" select id as numbering, `name` as surname from t_stu " # error, if there is a space in the field alias, then "thank you for reading" cannot be omitted! This is the end of this article on "what grammatical norms mysql has". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.