MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test_chinese_column_full_season(
`場地` varchar(60), 
`game_no` varchar(60));

INSERT INTO test_chinese_column_full_season
           (`場地`,`game_no`)
VALUES
('A','1'),
('B','1'),
('C','1'),
('D','1'),
('E','1'),
('A','2'),
('B','2'),
('C','2'),
('D','2'),
('E','2'),
('A','3'),
('B','3'),
('C','3'),
('D','3'),
('E','3');

SELECT *
FROM test_chinese_column_full_season;

Records: 15  Duplicates: 0  Warnings: 0




場地
game_no


A
1

B
1

C
1

D
1

E
1

A
2

B
2

C
2

D
2

E
2

A
3

B
3

C
3

D
3

E
3


CREATE TABLE game_information(
`ball_park` varchar(60), 
`game_no` varchar(60));

INSERT INTO game_information
           (`ball_park`,`game_no`)
VALUES
('X','1'),
('Y','2');

SELECT *
FROM game_information;

Records: 2  Duplicates: 0  Warnings: 0




ball_park
game_no


X
1

Y
2


UPDATE `test_chinese_column_full_season` t, `game_information` g
SET t.`場地` = g.`ball_park` WHERE t.`game_no` = g.`game_no`

Rows matched: 10  Changed: 10  Warnings: 0


-- 方法一:未變更資料
SELECT *
FROM test_chinese_column_full_season AS t
WHERE t.`場地` NOT IN (
SELECT g.`ball_park`
FROM game_information AS g
WHERE t.`game_no` = g.`game_no`
)


場地
game_no


A
3

B
3

C
3

D
3

E
3


-- 方法二:未變更資料筆數
SELECT COUNT(1) AS `Counter`
FROM test_chinese_column_full_season AS t
WHERE t.`場地` NOT IN (
SELECT g.`ball_park`
FROM game_information AS g
WHERE t.`game_no` = g.`game_no`
)


Counter


5


-- 方法三:變更後資料資料(目視差異)
SELECT *
FROM test_chinese_column_full_season;


場地
game_no


X
1

X
1

X
1

X
1

X
1

Y
2

Y
2

Y
2

Y
2

Y
2

A
3

B
3

C
3

D
3

E
3