wakchu
/ SQLCountries.sql
Created
October 7, 2025 14:52
SQL query for all the 193 contries members of the united nations (iso_code, name, region, lat, lon, timezone)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE country ( | |
| iso_code CHAR(2) NOT NULL, -- ISO 3166-1 alpha-2 (IT, US, FR, ...) | |
| name VARCHAR(150) NOT NULL, | |
| region VARCHAR(100), | |
| lat DECIMAL(9,6), | |
| lon DECIMAL(9,6), | |
| timezone VARCHAR(50), | |
| inserted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, | |
| PRIMARY KEY (iso_code) |