MySQL insert into Statement Exercises: Insert NULL values against region_id column for a row of countries table

MySQL insert into Statement: Exercise-4 with Solution

4. Write a SQL statement to insert NULL values against region_id column for a row of countries table.

Sample Solution:

INSERT INTO countries (country_id,country_name,region_id) VALUES('C1','India',NULL);

Let execute the above code in MySQL 5.6 command prompt.

Here is the structure of the table:

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

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

Previous:Write a SQL statement to create duplicate of countries table named country_new with all structure and data.
Next:Write a SQL statement to insert 3 rows by a single insert statement.