Vyhledávání
INSERT... SELECT
INSERT INTO table3
(id1, id2)
SELECT id1, id2 FROM table1, table2;
- consider use INSERT IGNORE
UPDATE... SELECT
UPDATE first_table, second_table
SET first_table.color = second_table.color
WHERE first_table.id = second_table.foreign_id
DELETE on multiple tables
DELETE a1, a2 FROM t1 AS a1 JOIN t2 AS a2 WHERE a1.id=a2.id;