MySQL Countries Table

Need a countries table for your database? This is a ready-to-import MySQL dump with 240 countries — complete with names, telephone dialing codes, and ISO codes. Just import it and you're set.

What's Included

The SQL dump contains a single table with the following fields for each of the 240 countries:

• Country Name
• Telephone Dialing Code (e.g., +92 for Pakistan, +1 for USA)
• 2-Digit ISO Code (e.g., PK, US, GB)
• 3-Digit ISO Code (e.g., PAK, USA, GBR)

How to Use It

Import the SQL file into your MySQL or MariaDB database using phpMyAdmin, the command line, or any database management tool. The table is ready to use immediately — no modifications needed.

Common Use Cases

This table is useful for any application that needs country data:

• Country dropdown menus in registration or checkout forms
• Phone number validation with dialing codes
• Shipping and billing address forms
• Localization and internationalization features
• Analytics and reporting by country

240 Records, Clean Data

The data covers all internationally recognized countries with consistent formatting. No duplicates, no missing codes, no encoding issues. It's the kind of reference table you set up once and use across multiple projects.