＜＜TYPE－P・沿線駅の新規登録用::train_new.txt＞＞
-- 1: 駅の存在確認(SELECT:count)
SELECT count(*) AS S_1 FROM m_station WHERE kin_cd='8-828-010';
SELECT count(*) AS S_2 FROM m_station WHERE kin_cd='8-828-020';
SELECT count(*) AS S_3 FROM m_station WHERE kin_cd='8-828-030';
SELECT count(*) AS S_4 FROM m_station WHERE kin_cd='8-828-040';

-- 2: 駅の表示(SELECT)
SELECT * FROM m_station WHERE kin_cd='8-828-010';
SELECT * FROM m_station WHERE kin_cd='8-828-020';
SELECT * FROM m_station WHERE kin_cd='8-828-030';
SELECT * FROM m_station WHERE kin_cd='8-828-040';

-- 3: 駅の新規追加(INSERT INTO)
INSERT INTO m_station (kin_cd, pref_cd, area_cd, line_cd, station_cd, _line_name, station_name) VALUES 
('8-828-010','38','8','828','010','伊予鉄道城南線', '道後温泉'),
('8-828-020','38','8','828','020','伊予鉄道城南線', '道後公園'),
('8-828-030','38','8','828','030','伊予鉄道城南線', '南町'),
('8-828-040','38','8','828','040','伊予鉄道城南線', '上一万');


＜＜TYPE－P・沿線駅の更新用::train_renew.txt＞＞
-- 1: 更新する駅の存在確認(SELECT:count)
SELECT count(*) AS S_1 FROM m_station WHERE kin_cd='4-482-130';

-- 2: 更新する駅の存在確認(SELECT:count)
SELECT * FROM m_station WHERE kin_cd='4-482-130';

-- 3: 駅の更新(UPDATE)
UPDATE m_station SET Station='熱田神宮西',Kin_Station
='熱田神宮西' WHERE kin_cd='4-482-130';