PHP 连接 3 个表，然后插入到第 4 个表 - php join 3 tables then insert to 4th

php join 3 tables then insert to 4th

本文关键字：个表插入连接 PHP 然后 | 更新日期: 2023-09-27

这里是JOIN：

SELECT 
    gc3025_raid_results.raid_id, 
    gc3025_game_units.planet_id, 
    gc3025_game_units.g_dist, 
    gc3025_game_units.unit_name, 
    gc3025_units_base.unit_type, 
    gc3025_game_units.code, 
    gc3025_game_units.cdamage, 
    gc3025_units_base.defense_raid_score, 
    gc3025_units_base.raid_damage 
FROM gc3025_game_units 
    JOIN gc3025_units_base 
        ON gc3025_game_units.code = gc3025_units_base.unit_code 
    JOIN gc3025_raid_results 
        ON gc3025_raid_results.district_idg = gc3025_game_units.g_dist

然后我需要插入到另一个表中

INSERT INTO gc3025_raid_defenders( 
    raid_ids, planet_id, district_id, 
    unit_name, unit_type, unit_code, 
    raid_score, raid_damage)
    SELECT ... (see above) ...

任何建议将不胜感激。

这应该可以让您继续前进，但您需要添加其他字段。确保 insert（）中字段的名称和顺序与 select（）中的字段匹配

insert into gc3025_raid_defenders (raid_ids, planet_id, etc...)
select (gc3025_raid_results.raid_id, gc3025_game_units.planet_id, etc...)
from gc3025_game_units gu
join gc3025_units_base ub
    on gu.code = ub.unit_code
join gc3025_raid_results rr
    on gu.g_dist = rr. district_idg

附带说明一下，如果可能的话，请考虑在表之间一致地命名字段g_dist。