SK3Wiki

create table cqww_spots(
 id INT NOT NULL  PRIMARY KEY AUTO_INCREMENT, 
 callsign varchar(20) NOT NULL,
 de_pfx varchar(6) NOT NULL,
 de_cont varchar(3) NOT NULL,
 freq varchar(10) NOT NULL,
 band varchar(5) NOT NULL,
 dx varchar(20) NOT NULL,
 dx_pfx varchar(6) NOT NULL,
 dx_cont varchar(3) NOT NULL, 
 mode varchar(5),
 db INT,
 date DATETIME); 

LOAD DATA LOCAL INFILE '/home/common/skimmer/cqww2011/20111126_nohead.csv'
INTO TABLE cqww_spots
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(callsign, de_pfx, de_cont, freq, band, dx, dx_pfx, dx_cont, mode, db, date);
[18:17:32] Torgny: jag editerade csv-filen och raderade rad1 som innehöll headern