create database capital;

use capital;

create table capital(name varchar(30) not null, longitude float, latitude
 float);

load data local infile 'capital.txt' into table capital

fields terminated by ',' lines terminated by '\r\n' ignore 1 lines

(latitude,longitude,name);

quit