How do we insert data into a MySQL table?

To insert data into a MySQL table, we need to use the INSERT INTO command. We have to specify the values ​​of all the columns in the table in the INSERT INTO command.

Syntax

INSERT INTO table_name values(value1,value2,…)

Example

Suppose we have a table named "Student" which contains three columns "RollNo", "Name" and "Class", then With the help of the following query we can add new rows to the table -

mysql> INSERT INTO Student values(50,'Harshit',’B.tech’);
Query OK, 1 row affected (0.07 sec)

mysql> INSERT INTO Student values(56,'Amit',’M.tech’);
Query OK, 1 row affected (0.05 sec)

mysql> Select * from Student;
+---------+-------------+-----------+
| RollNo  | Name        | Class     |
+---------+-------------+-----------+
|  50     | Harshit     | B.tech    |  
|  56     |  Amit       | M.tech    |
+---------+-------------+-----------+
2 rows in set (0.00 sec)

The above is the detailed content of How do we insert data into a MySQL table?. For more information, please follow other related articles on the PHP Chinese website!