Копирование через UPDATE столбца col2 из одной таблицы в другую, при условии, что PRIMARY KEY составной

UPDATE orders1 SET titleO = (SELECT titleO FROM orders WHERE orderNumber = orders1.orderNumber)

UPDATE nomer4 SET col2=(SELECT col2 FROM nomer1 WHERE (id1,id2)=nomer4.(id1,id2))

UPDATE nomer4 SET col2=(SELECT col2 FROM nomer1 WHERE id1 = nomer4.id1 AND id2 =nomer4.id2)

UPDATE magaz.nomer2 SET col1, col2 =(SELECT col1, col2 FROM nomer1 WHERE id1=id1.nomer2 AND id2=id2.nomer2)

UPDATE magaz.nomer2 SET col1, col2 =(SELECT col1, col2 FROM nomer1 WHERE id1=nomer2.id1 AND id2= nomer2.id2)

DELIMITER $$
CREATE TRIGGER nom_i AFTER INSERT ON nomer1 
FOR EACH ROW 
BEGIN 
INSERT INTO nomer4 (id1, id2, col1, col2) VALUES (NOW.id1, NOW.id2, NOW.col1, NOW.col2); 
INSERT INTO magaz.nomer2 (id1, id2, col1, col2) VALUES (NOW.id1, NOW.id2, NOW.col1, NOW.col2); 
END $$
DELIMITER ;

INSERT INTO nomer1 (id1, id2, col1, col2) VALUES (4, 40, 6, 444)

DROP TRIGGER IF EXISTS newprofile;  /*пересоздание триггера при импорте*/
DELIMITER $$
CREATE TRIGGER newprofiless AFTER INSERT ON users_t /*после вставки в таблицу users*/
FOR EACH ROW
BEGIN
INSERT INTO profiless_t(user_id) VALUES (NEW.id);  /*вставить в таблицу profiles_t*/
END $$
DELIMITER ;

CREATE TRIGGER snip_p AFTER INSERT ON snip
FOR EACH ROW
BEGIN
INSERT INTO snip1 (snip_vg, oruzh, price) VALUES (NEW.snip_vg, NEW.oruzh, NEW.price);
END $$