How do we insert new rows into a MySQL table?

New rows can be inserted into the table with the help of the INSERT INTO command.

Syntax

INSERT INTO table_name values(value1,value2,…)

Example

Suppose we have a table named "Employee" which contains three columns "Emp_id", "Emp_name" and "Emp_Sal", then With the help of the following query we can add new rows to the table -

mysql> INSERT INTO Employee values(110,'Aarav',50000);
Query OK, 1 row affected (0.07 sec)

mysql> INSERT INTO Employee values(200,'Raman',28000);
Query OK, 1 row affected (0.10 sec)

mysql> Select * from Employee;
+---------+-------------+-----------+
| Emp_id  | Emp_name    | Emp_sal   |
+---------+-------------+-----------+
| 110     |Aarav        | 50000     |
| 200     | Raman       | 28000     |
+---------+-------------+-----------+
2 rows in set (0.00 sec)

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