1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| -- ==============
-- Table `cities`
-- ==============
DROP TABLE IF EXISTS Cities;
CREATE TABLE Cities (
Country CHAR(2),
City CHAR(22),
AccentCity CHAR(3),
Region CHAR(2),
Population INT UNSIGNED NULL DEFAULT NULL,
Latitude FLOAT,
Longitude FLOAT
) ENGINE=InnoDB
DEFAULT CHARSET=`utf8` COLLATE=`utf8_general_ci`;
-- ===============================
-- Chargement de la table `cities`
-- ===============================
LOAD DATA LOCAL INFILE 'Charge.txt' INTO TABLE `Cities`
CHARACTER SET latin1
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 0 LINES
(@F1, @F2, @F3, @F4, Population, Latitude, Longitude)
set Country = trim(@F1),
City = trim(@F2),
AccentCity = trim(@F3),
Region = trim(@F4); |
Partager