更新数据


UPDATE zfuwl_game_fight_produce t1  
JOIN zfuwl_game_fight_produce t2 ON t1.name_cn = t2.name_cn  
SET t2.aggressivity = t1.aggressivity,t2.health_value = t1.health_value,t2.generate_species = t1.generate_species,t2.meat_num = t1.meat_num,
t2.price = t1.price,t2.enemy_aggressivity = t1.enemy_aggressivity,t2.enemy_health_value = t1.enemy_health_value
WHERE t1.timeline_id = 1 AND t2.timeline_id != 1;


UPDATE zfuwl_game_fight_produce t1  
JOIN zfuwl_game_fight_produce t2 ON t1.fight_id = (t2.fight_id%6)  
SET t2.basis_value = t1.basis_value
WHERE t1.timeline_id = 1 AND t2.timeline_id != 1;zfuwl_game_fight



评论0



    0.198302s