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!