<<沿線・駅の新規登録：train_new.txt>>
-- 1: 駅の存在確認(SELECT:count)
SELECT count(*) AS S_1 FROM m_station WHERE area_cd='8' AND line_cd='828' AND station_cd='010';
SELECT count(*) AS S_2 FROM m_station WHERE area_cd='8' AND line_cd='828' AND station_cd='020';
SELECT count(*) AS S_3 FROM m_station WHERE area_cd='8' AND line_cd='828' AND station_cd='030';
SELECT count(*) AS S_4 FROM m_station WHERE area_cd='8' AND line_cd='828' AND station_cd='040';

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

-- 3: 駅の新規追加(INSERT INTO)
set @m_station_max_id = (SELECT max(TRAIN_MAIN_ID) FROM m_station);
INSERT INTO m_station (TRAIN_MAIN_ID, area_cd, pref_cd, line_cd, station_cd, _line_name, station_name) VALUES 
(@m_station_max_id+1,'8','38','828','010','伊予鉄道城南線', '道後温泉'),
(@m_station_max_id+2,'8','38','828','020','伊予鉄道城南線', '道後公園'),
(@m_station_max_id+3,'8','38','828','030','伊予鉄道城南線', '南町'),
(@m_station_max_id+4,'8','38','828','040','伊予鉄道城南線', '上一万');


<<沿線・駅の更新：train_renew.txt>>
-- 1: 更新する駅の存在確認(SELECT:count)
SELECT count(*) AS S_1 FROM m_station WHERE area_cd='4' AND line_cd='482' AND station_cd='130';

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

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