我认为您正在寻找UNION子句,
(SELECT * from us_music where `genre` = 'punk')
UNION
(SELECT * from de_music where `genre` = 'punk')
MySQL-从多个具有相同结构但数据不同的表中选择数据
我认为您正在寻找UNION子句,
(SELECT * from us_music where `genre` = 'punk')
UNION
(SELECT * from de_music where `genre` = 'punk')