1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| CREATE TABLE IF NOT EXISTS country_list (
code VARCHAR(2),
country_code smallint(11) DEFAULT NULL,
dial_code smallint(11) DEFAULT NULL,
id_code int(11) NOT NULL,
name varchar(90) DEFAULT NULL
)ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO country_list VALUES
('AF','0093','+93','1','Afghanistan'),
('AL','00355','+355',' 2','Albania'),
('DZ','00213','+213','3','Algerie'),
('AS','001684','+1 684','4','AmericanSamoa'),
('AD','00376','+376','5','Andorra'),
('AO','00244','+244','6','Angola'),
('AI','001264 ','+1 264','7','Anguilla'),
('AG','001268 ','+1268','8','Antigua and Barbuda'),
('AR','0054','+54','9','Argentina'),
('AM','00374','+374','10','Armenia'),
('AW','00297','+297','11','Aruba') |
Partager