Insert script for all Countries

Many times require to insert all countries into a database system. This list of Country data is stored in database as Master data of the application.

The application has to just select list of Countries from this country table.

Below is a sample Country table and  insert script for all Countries:

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from

Sort by:   newest | oldest | most voted

Hi Anvesh,
Exactly I am also find something like prepared script, and I have executed this script in MySQL and SQL Server both.
You worked for me
Thanks !

ray ban

Good day! This is my 1st comment here so I just wanted to give a quick shout out and say I truly enjoy reading your blog posts. Can you recommend any other blogs/websites/forums that go over the same topics? Thanks for your time!