SET NAMES utf8;


LOAD DATA INFILE 'naissances2007.csv' 
INTO TABLE naiss2007  
CHARACTER SET utf8 
FIELDS TERMINATED BY ',' optionally ENCLOSED BY '"' 
IGNORE 1 LINES ;


LOAD DATA INFILE 'naissances2006.csv' 
INTO TABLE naiss2006  
CHARACTER SET utf8 
FIELDS TERMINATED BY ',' optionally ENCLOSED BY '"' 
IGNORE 1 LINES ;


LOAD DATA INFILE 'naissances2005.csv' 
INTO TABLE naiss2005  
CHARACTER SET utf8 
FIELDS TERMINATED BY ',' optionally ENCLOSED BY '"' 
IGNORE 1 LINES ;


LOAD DATA INFILE 'naissances2004.csv' 
INTO TABLE naiss2004  
CHARACTER SET utf8 
FIELDS TERMINATED BY ',' optionally ENCLOSED BY '"' 
IGNORE 1 LINES ;


LOAD DATA INFILE 'naissances2003.csv' 
INTO TABLE naiss2003  
CHARACTER SET utf8 
FIELDS TERMINATED BY ',' optionally ENCLOSED BY '"' 
IGNORE 1 LINES ;


LOAD DATA INFILE 'naissances2002.csv' 
INTO TABLE naiss2002  
CHARACTER SET utf8 
FIELDS TERMINATED BY ',' optionally ENCLOSED BY '"' 
IGNORE 1 LINES ;


LOAD DATA INFILE 'naissances2001.csv' 
INTO TABLE naiss2001  
CHARACTER SET utf8 
FIELDS TERMINATED BY ',' optionally ENCLOSED BY '"' 
IGNORE 1 LINES ;


LOAD DATA INFILE 'naissances2000.csv' 
INTO TABLE naiss2000  
CHARACTER SET utf8 
FIELDS TERMINATED BY ',' optionally ENCLOSED BY '"' 
IGNORE 1 LINES ;


LOAD DATA INFILE 'naissances1999.csv' 
INTO TABLE naiss1999  
CHARACTER SET utf8 
FIELDS TERMINATED BY ',' optionally ENCLOSED BY '"' 
IGNORE 1 LINES ;

