Home > Database > Mysql Tutorial > How to increase the number of records in mysql

How to increase the number of records in mysql

青灯夜游
Release: 2023-01-04 16:31:27
Original
14746 people have browsed it

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.

How to increase the number of records in mysql

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) ];
Copy after login

The syntax is as follows: