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

How to write the syntax of adding records in mysql database? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The record code added to the mysql database is "INSERT INTO table name (column name 1, column name 2, … column name n) VALUES (value 1, value 2, … value n); when inserting data, the column names after the INSERT statement do not need to be inserted in the order defined by the table, as long as the order of the values is the same as the order of the column fields.

The method of adding Records in mysql Database

In MySQL, you can use the INSERT statement to insert one or more rows of records into an existing table in the database.

Grammatical format

INSERT INTO table name (column name 1, column name 2, … Column name n) VALUES (values 1, 2,... Value n)

The syntax is explained as follows.

Table name: specifies the name of the table being manipulated.

Column name: specifies the name of the column in which data needs to be inserted. If you insert data into all the columns in the table, all column names can be omitted and directly use INSERTVALUES (...) That's it.

VALUES clause: this clause contains the list of data to insert. The order of the data in the data list corresponds to the order of the columns.

If the data is character type, you must use single or double quotation marks, such as "value".

Example:

View data from the tb_courses table

Mysql > SELECT * FROM tb_courses;Empty set (0.00 sec)

The query results show that the content of the current table is empty and there is no data. Next, the operation of inserting data is performed, and a new record is inserted in the tb_courses table. The course_id value is 1 Network, the course_grade value is 3, and the info value is "Computer Network".

Mysql > INSERT INTO tb_courses-> (course_id,course_name,course_grade,course_info)-> VALUES; Query OK, 1 rows affected (0.08 sec) mysql > SELECT * FROM tb_courses +-+ | course_id | course_name | course_grade | course_info | +-+ -+ | 1 | Network | 3 | Computer Network | +-+ 1 row in set (0.00 sec)

You can see that the record was inserted successfully. When you insert data, all fields of the tb_courses table are specified, so a new value is inserted for each field.

The order of column names after the INSERT statement may not be the order in which the tb_courses table is defined, that is, when inserting data, you do not need to insert data in the order defined by the table, as long as you ensure that the order of the values is the same as the order of the column fields.

When inserting data using INSERT, the column name list column_list is allowed to be empty, where values need to be specified for each field in the table, and the order of values must be the same as when the fields in the data table were defined.

Example: insert a new record in the tb_courses table with a course_id value of 2, a course_grade value of 3, and an info value of "MySQL". The SQL statement entered and the execution result are shown below.

Mysql > INSERT INTO tb_courses-> VLAUES; Query OK, 1 rows affected (0.08 sec) mysql > SELECT * FROM tb_courses +-+ | course_id | course_name | course_grade | course_info | +-+ -+ | 1 | Network | 3 | Computer Network | | 2 | Database | 3 | MySQL | +-+ 2 rows in set (0.00 sec)

There is no insert list specified in the INSERT statement, only a list of values. In this case, the values list specifies the inserted values for each field column, and the order of these values must be the same as the order defined by the fields in the tb_courses table.

Note: although the column name of the inserted data can be ignored when inserting data using INSERT, if the value does not contain a column name, the values after the VALUES keyword must not only be complete, but must also be in the same order as the columns when the table was defined. If the structure of the table is modified, columns are added, deleted, or relocated, which will change the order in which data is inserted in this way. If you specify a column name, it is not affected by changes in the table structure.

Thank you for reading! After reading the above, do you have a general understanding of the syntax of adding records in the mysql database? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to 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.