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?



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://w3resource.com/mysql-exercises/insert-into-statement/insert-into-statement-exercise-1.php