USE quality;

SET NAMES cp1251;
SET character_set_filesystem = cp1251;
SET character_set_database = cp1251;
SET character_set_server = cp1251;

LOAD DATA  LOCAL INFILE "C://214.txt"

    INTO TABLE `temp_214`
    CHARACTER SET cp1251
    FIELDS
      TERMINATED BY ';'
      ENCLOSED BY '"'

   LINES
      TERMINATED BY '\r\n'
/*   IGNORE 1 LINES */ 
     ( `Кокиль`, `Дефект`,`Локация` , `Автор`, `Стержень`)

 set `id`= null;



LOAD DATA  LOCAL INFILE "C://126.txt"

    INTO TABLE `quality`.`temp_126`
    CHARACTER SET cp1251
    FIELDS
      TERMINATED BY ';'
      ENCLOSED BY '"'

    LINES
      TERMINATED BY '\r\n'
/*   IGNORE 1 LINES */ 
     ( `Кокиль`, `Дефект`,`Локация` , `Автор`, `Стержень`)
     set `id`= null;



LOAD DATA LOCAL INFILE "C://183.txt"

    INTO TABLE `quality`.`tb_183`
    CHARACTER SET cp1251
    FIELDS
      TERMINATED BY ';'
      ENCLOSED BY '"'

    LINES
      TERMINATED BY '\r\n'
/*   IGNORE 1 LINES */
     ( `Кокиль`, `Дефект`,`Локация` , `Автор`, `Стержень`)
     set `id`= null;



/*    
select*from `temp_126`;
select*from `tb_126`;
select*from `tb_194`;  */

select*from `temp_214`;
select*from `tb_214`;
select*from `tb_214_73`;
select*from `tb_011`;

/*select*from `tb_183`;*/

TRUNCATE `temp_214`; 
TRUNCATE `tb_214`;
TRUNCATE `tb_214_73`; 
TRUNCATE `tb_011`;

TRUNCATE `tb_183`; 

TRUNCATE `temp_126`;
TRUNCATE `tb_194`;