How to increase the number of records in mysql

In MySQL, you can use the INSERT statement to add a record number to the database. The INSERT statement has two formats: 1. "INSERT INTO table name [column name 1,...column name n] VALUES (value 1..., Value n);", you can insert a row of all column data into the table; 2. "INSERT INTO table name SET column name 1=value 1, column name 2=value 2,...;", you can insert a row of partial columns into the table data.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

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

The INSERT statement has two grammatical forms, namely the INSERT…VALUES statement and the INSERT…SET statement.

Method 1: Use the INSERT...VALUES statement to increase the number of records

The syntax format is:

INSERT INTO <表名> [ <列名1> [ , … <列名n>] ]
VALUES (值1) [… , (值n) ];

The syntax is as follows:

• : Specify the name of the table to be operated on.

  : Specify the column name into which data needs to be inserted. If data is inserted into all columns in the table, all column names can be omitted, and INSERT

  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】

The above is the detailed content of How to increase the number of records in mysql. For more information, please follow other related articles on the PHP Chinese website!