CREATE TABLE `streets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `i_name` (`name`)
) ENGINE=InnoDB;

CREATE TABLE `mkd` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_street` int(11) DEFAULT NULL,
  `addr_building` varchar(5) DEFAULT NULL,
  `addr_letter` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mk_sbl` (`id_street`,`addr_building`,`addr_letter`),
  KEY `fk_street` (`id_street`),
  CONSTRAINT `fk_street` FOREIGN KEY (`id_street`) REFERENCES `streets` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB; 

CREATE TABLE `csv_1` (
  `id_mkd` int(11) DEFAULT '0',
  `addr_street` varchar(30) DEFAULT NULL,
  `addr_building` varchar(5) DEFAULT NULL,
  `addr_letter` varchar(3) DEFAULT NULL,
  `addr_flat` varchar(8) DEFAULT NULL,
  KEY `mk` (`addr_street`,`addr_building`,`addr_letter`)
) ENGINE=InnoDB;

UPDATE csv_1 c SET id_mkd=(
	SELECT id FROM mkd m 
	WHERE (id_street=(SELECT id FROM streets WHERE name=addr_street)) AND (m.addr_building=c.addr_building) AND (m.addr_letter=c.addr_letter)
)

UPDATE csv_1,mkd SET csv_1.id_mkd=mkd.id
WHERE ...

UPDATE csv_1,mkd SET csv_1.id_mkd=mkd.id
WHERE (mkd.id_street=(SELECT id FROM streets WHERE name=csv_1.addr_street)) AND (mkd.addr_building=csv_1.addr_building) AND (mkd.addr_letter=csv_1.addr_letter)

UPDATE csv_1 c, mkd m, streets s
SET c.id_mkd=m.id
WHERE c.addr_street = s.name
  AND c.addr_building = m.addr_building
  AND IFNULL(c.addr_letter,0) = IFNULL(m.addr_letter,0)
  AND s.id = m.id_street