w3resource

Insert a custom record into a MySQL table

MySQL insert into Statement: Exercise-1 with Solution

1. Write a MySQL query to insert a record with your own value into the table countries against each columns.

Here is the structure of the table "countries".

+--------------+---------------+------+-----+---------+-------+
| Field        | Type          | Null | Key | Default | Extra |
+--------------+---------------+------+-----+---------+-------+
| COUNTRY_ID   | varchar(2)    | YES  |     | NULL    |       |
| COUNTRY_NAME | varchar(40)   | YES  |     | NULL    |       |
| REGION_ID    | decimal(10,0) | YES  |     | NULL    |       |
+--------------+---------------+------+-----+---------+-------+	

Sample Solution:

-- Inserting a new record into the 'countries' table
INSERT INTO countries VALUES('C1','India',1001);

Let execute the above code in MySQL command prompt.

Here is the structure of the table:

mysql> SELECT * FROM countries;
+------------+--------------+-----------+
| COUNTRY_ID | COUNTRY_NAME | REGION_ID |
+------------+--------------+-----------+
| C1         | India        |      1001 |
+------------+--------------+-----------+
1 row in set (0.00 sec)

Explanation:

The above code inserts a new record into the 'countries' table, setting the 'country_id' as 'C1', 'country_name' as 'India', and 'region_id' as 1001.

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous:MySQL Insert Rows into the Table
Next:Write a MySQL query to insert one row into the table countries against the column country_id and country_name.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.