I make this step:
- Code: Select all
-- Database: `world`
CREATE DATABASE `world`;
USE `world`;
-- Table: `cities`
CREATE TABLE IF NOT EXISTS `cities` (
`Country` CHAR(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`City` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`AccentCity` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`Region` CHAR(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`Population` INT(10) UNSIGNED NOT NULL,
`Latitude` FLOAT NOT NULL,
`Longitude` FLOAT NOT NULL,
KEY `AccentCity` (`AccentCity`(5)),
KEY `City` (`City`(5))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOAD DATA LOCAL INFILE 'worldcitiespop.txt'
INTO TABLE `cities`
FIELDS
TERMINATED BY ','
LINES
TERMINATED BY '\n'
IGNORE 1 LINES;
In this state my db is useless!
tnx in advance