How do we add values ​​to columns of MySQL table?

The INSERT command is used to add values ​​to columns of a MySQL table. We need to specify values ​​for all the columns in the INSERT command as shown below-

Syntax

INSERT INTO table_name values(value1,value2,…)

Example

Suppose we have a table named "Stock" where Contains three columns "Item_id", "Item_name" and "Item_rate" then with the help of the following query we can add values ​​in these columns.

mysql> INSERT INTO Stock values(1,'HistoryBook',250);
Query OK, 1 row affected (0.07 sec)

mysql> INSERT INTO Stock values(2,'DBMSBook',280);
Query OK, 1 row affected (0.10 sec)

mysql> Select * from Stock;
+---------+-------------+-----------+
| item_id | Item_name   | Item_rate |
+---------+-------------+-----------+
| 1       | HistoryBook | 250       |
| 2       | DBMSBook    | 280       |
+---------+-------------+-----------+
2 rows in set (0.00 sec)

The above is the detailed content of How do we add values ​​to columns of MySQL table?. For more information, please follow other related articles on the PHP Chinese website!