9 lines
301 B
SQL
9 lines
301 B
SQL
UPDATE `sys_game_list_config` cfg
|
|
JOIN `sys_game_list_vendor_ext` ext
|
|
ON ext.game_list_config_id = cfg.id
|
|
AND ext.vendor_type = 'BAISHUN'
|
|
SET cfg.category = 'CHAT_ROOM'
|
|
WHERE cfg.game_origin = 'BAISHUN'
|
|
AND COALESCE(cfg.category, '') <> 'CHAT_ROOM'
|
|
AND COALESCE(cfg.game_mode, '') LIKE '%2%';
|