VALUES(…) can be used directly. VALUES or VALUE clause: This clause contains the list of data to be inserted. The order of data in the data list should correspond to the order of columns.
Example:
Create a course information table tb_courses in the test_db database, including course number course_id, course name course_name, course credits course_grade and Course notes course_info
CREATE TABLE tb_courses(
course_id INT NOT NULL AUTO_INCREMENT,
course_name CHAR(40) NOT NULL,
course_grade FLOAT NOT NULL,
course_info CHAR(100) NULL,
PRIMARY KEY(course_id)
);
View the data of the tb_courses table
SELECT * FROM tb_courses;
##Insert a new record in the tb_courses table, course_id The value is 1, the course_name value is "Network", the course_grade value is 3, and the info value is "Computer Network". INSERT INTO tb_courses(course_id,course_name,course_grade,course_info)
VALUES(1,'Network',3,'Computer Network');
After inserting, you can see that the inserted record is successful when querying the data
. When inserting data, all fields of the tb_courses table are specified, so new values will be inserted for each field.
Method 2: Use the INSERT...SET statement to increase the number of records
The syntax format is: INSERT INTO <表名>
SET <列名1> = <值1>,
<列名2> = <值2>,
…
This statement is used to directly specify corresponding column values for certain columns in the table, that is, the column name of the data to be inserted is specified in the SET clause, col_name is the specified column name, and the equal sign is followed by the specified data. , and for unspecified columns, the column value is assigned the default value for that column.
Example:
Insert a new record in the tb_courses table, the course_id value is 2, the course_name value is "Database", the course_grade value is 3, and the info value is " MySQL". INSERT INTO tb_courses
SET course_name = 'Database',
course_info = 'MySQL',
course_id = 2,
course_grade = 3;
After inserting, you can see that the inserted record is successful when querying the data
.
Instructions:
Two forms of INSERT statement:
- Use INSERT The …VALUES statement can insert one row of data or multiple rows of data into the table;
- The INSERT…SET statement can be used to specify the value of each column in the inserted row, or to specify some columns. The value;
- The INSERT...SET statement can be used to insert the values of some columns into the table. This method is more flexible;
- INSERT ...VALUES statement can insert multiple pieces of data at one time.
In MySQL, processing multiple inserts with a single INSERT statement is faster than using multiple INSERT statements. When using a single INSERT statement to insert multiple rows of data, you only need to enclose each row of data in parentheses.
【Related recommendations: mysql video tutorial】