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!