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