通过临时表批量更新部分字段

2018-03-08 15:05:40 阅读:2 编辑

1. 借用另一张表 ( 创建 slots_new 表从 slots 表)

2. 清空,从 Excel 复制到 slots_new

3.ALTER TABLE slot.slots ADD game_description VARCHAR (50) DEFAULT "" NULL;

4. 执行已经命令。当 slots_new 只有 slots 一部分时,必须带 where

UPDATE slots s SET s.game_name_en=(
    SELECT game_name_en
    FROM slots_new
    WHERE id=s.id
) where platform='Ttg'

UPDATE slots s SET s.game_description=(
    SELECT game_description
    FROM slots_new
    WHERE id=s.id
) where platform='Ttg'