Shulou(Shulou.com)05/31 Report--

What are the knowledge points of this article "what are the grammatical norms of mysql?" most people do not understand, so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "what are the grammatical specifications of mysql?"

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 you cannot omit the above article on "what are the grammatical specifications of mysql". I believe you all have some understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about the relevant knowledge, please follow the industry information channel.

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.