`countries_isd_code` varchar(7) DEFAULT NULL,

`countries_iso_code` varchar(2) NOT NULL,

`countries_name` varchar(64) NOT NULL DEFAULT '', `countries_id` int(11) NOT NULL AUTO_INCREMENT, This script can be used on project like E-commerce system, Hotel Management System, Classified and so on, in which countries name are an important aspect of the project. Just download or copy the script and use it in your project. I have put all the countries name with the Alpha-2 ISO Code along with the country International Subscriber Dialing ( ISD Code) which I think will help you a lot. So I have put a list of all countries name with ISD and ISO code in SQL and CSV format and published here. I have used countries names list in almost every project I have done. Countries names list are one of the most common part of every project.