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`;