http://jendo.org/alWiki/index.php?action=history&feed=atom&title=%E5%85%AC%E4%BF%9D%E8%88%87%E5%8B%9E%E4%BF%9D%E8%B3%87%E6%96%99%E5%8C%AF%E5%85%A5
公保與勞保資料匯入 - 修訂歷史
2026-06-09T14:43:35Z
本 Wiki 上此頁面的修訂歷史
MediaWiki 1.35.1
http://jendo.org/alWiki/index.php?title=%E5%85%AC%E4%BF%9D%E8%88%87%E5%8B%9E%E4%BF%9D%E8%B3%87%E6%96%99%E5%8C%AF%E5%85%A5&diff=10154&oldid=prev
丁志仁：/* 諸 SQL 指令 */
2026-05-10T13:00:45Z
<p><span dir="auto"><span class="autocomment">諸 SQL 指令</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">於 2026年5月10日 (日) 13:00 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l64" >行 64：</td>
<td colspan="2" class="diff-lineno">行 64：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從過往的檔案抄「update 2025公保校名 a left join 2025postSchool b on a.原始校名=b.schoolName SET a.schoolCode=b.schoolCode where b.schoolName is not null」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從過往的檔案抄「update 2025公保校名 a left join 2025postSchool b on a.原始校名=b.schoolName SET a.schoolCode=b.schoolCode where b.schoolName is not null」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從教育部編碼抄</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從教育部編碼抄</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#*#抄校名相同者10所國立非大學「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=b.學校名稱 set a.schoolCode=b.schoolCode where a.schoolCode=<del class="diffchange diffchange-inline">'' </del>&& b.schoolCode is not null」</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#*#抄校名相同者10所國立非大學「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=b.學校名稱 set a.schoolCode=b.schoolCode where a.schoolCode=<ins class="diffchange diffchange-inline">&#39;&#39; </ins>&& b.schoolCode is not null」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄 102 所縣市立高中，如「新北市立泰山高級中學」，「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(concat(SUBSTRING(縣市名稱,5,2),學校名稱),CHAR_LENGTH(concat(SUBSTRING(縣市名稱,5,2),學校名稱))-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中%'」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄 102 所縣市立高中，如「新北市立泰山高級中學」，「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(concat(SUBSTRING(縣市名稱,5,2),學校名稱),CHAR_LENGTH(concat(SUBSTRING(縣市名稱,5,2),學校名稱))-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中%'」</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立高中「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中' && b.學校名稱 like '國立%' && a.schoolCode=<del class="diffchange diffchange-inline">'' </del>&& b.schoolCode is not null」</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立高中「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中' && b.學校名稱 like '國立%' && a.schoolCode=<ins class="diffchange diffchange-inline">&#39;&#39; </ins>&& b.schoolCode is not null」</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立女中「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'子高級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '國立%' && b.學校名稱 like '%女中' && a.schoolCode=<del class="diffchange diffchange-inline">'' </del>&& b.schoolCode is not null」</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立女中「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'子高級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '國立%' && b.學校名稱 like '%女中' && a.schoolCode=<ins class="diffchange diffchange-inline">&#39;&#39; </ins>&& b.schoolCode is not null」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 填 勞保校名 的 scode</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 填 勞保校名 的 scode</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從過往的檔案抄「update 2025勞保校名 a left join 2025postSchool b on a.原始校名=b.schoolName SET a.schoolCode=b.schoolCode where b.schoolName is not null」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從過往的檔案抄「update 2025勞保校名 a left join 2025postSchool b on a.原始校名=b.schoolName SET a.schoolCode=b.schoolCode where b.schoolName is not null」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從教育部編碼抄</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從教育部編碼抄</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立高中「UPDATE 2025勞保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中' && b.學校名稱 like '國立%' && a.schoolCode=<del class="diffchange diffchange-inline">'' </del>&& b.schoolCode is not null」</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立高中「UPDATE 2025勞保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中' && b.學校名稱 like '國立%' && a.schoolCode=<ins class="diffchange diffchange-inline">&#39;&#39; </ins>&& b.schoolCode is not null」</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立女中「UPDATE 2025勞保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'子高級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '國立%' && b.學校名稱 like '%女中' && a.schoolCode=<del class="diffchange diffchange-inline">'' </del>&& b.schoolCode is not null」</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立女中「UPDATE 2025勞保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'子高級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '國立%' && b.學校名稱 like '%女中' && a.schoolCode=<ins class="diffchange diffchange-inline">&#39;&#39; </ins>&& b.schoolCode is not null」</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#*從公保校名抄「UPDATE 2025勞保校名 a left join 2025公保校名 b using(原始校名) set a.schoolCode=b.schoolCode where a.schoolCode=<del class="diffchange diffchange-inline">'' </del>&& b.schoolCode is not null」</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#*從公保校名抄「UPDATE 2025勞保校名 a left join 2025公保校名 b using(原始校名) set a.schoolCode=b.schoolCode where a.schoolCode=<ins class="diffchange diffchange-inline">&#39;&#39; </ins>&& b.schoolCode is not null」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」<br/>---------- 以 MySQL 腳本命令派 scode 給公保資料與勞保資料 ----------</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」<br/>---------- 以 MySQL 腳本命令派 scode 給公保資料與勞保資料 ----------</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># /usr/local/mariadb10/bin/mysql -u root -p密碼 --database=資料庫名 < 待匯入腳本.sql</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># /usr/local/mariadb10/bin/mysql -u root -p密碼 --database=資料庫名 < 待匯入腳本.sql</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#*「UPDATE 2025公保資料 a left join 2025公保校名 b on a.學校名稱=b.原始校名 set a.schoolCode=b.schoolCode where a.schoolCode=<del class="diffchange diffchange-inline">'' </del>&& b.schoolCode is not null;」</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#*「UPDATE 2025公保資料 a left join 2025公保校名 b on a.學校名稱=b.原始校名 set a.schoolCode=b.schoolCode where a.schoolCode=<ins class="diffchange diffchange-inline">&#39;&#39; </ins>&& b.schoolCode is not null;」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====待批次處理：====</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====待批次處理：====</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 台→臺（資料表上沒有「台北市」這種簡寫）</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 台→臺（資料表上沒有「台北市」這種簡寫）</div></td></tr>
</table>
丁志仁
http://jendo.org/alWiki/index.php?title=%E5%85%AC%E4%BF%9D%E8%88%87%E5%8B%9E%E4%BF%9D%E8%B3%87%E6%96%99%E5%8C%AF%E5%85%A5&diff=10153&oldid=prev
丁志仁：/* 諸 SQL 指令 */
2026-05-10T03:59:33Z
<p><span dir="auto"><span class="autocomment">諸 SQL 指令</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">於 2026年5月10日 (日) 03:59 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l76" >行 76：</td>
<td colspan="2" class="diff-lineno">行 76：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」<br/>---------- 以 MySQL 腳本命令派 scode 給公保資料與勞保資料 ----------</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」<br/>---------- 以 MySQL 腳本命令派 scode 給公保資料與勞保資料 ----------</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># /usr/local/mariadb10/bin/mysql -u root -p密碼 < <del class="diffchange diffchange-inline">/volume1/homes/adminNas/www/wiki</del>.sql</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># /usr/local/mariadb10/bin/mysql -u root -p密碼 <ins class="diffchange diffchange-inline">--database=資料庫名 </ins>< <ins class="diffchange diffchange-inline">待匯入腳本</ins>.sql</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#*「UPDATE 2025公保資料 a left join 2025公保校名 b on a.學校名稱=b.原始校名 set a.schoolCode=b.schoolCode where a.schoolCode='' && b.schoolCode is not null;」</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====待批次處理：====</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====待批次處理：====</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 台→臺（資料表上沒有「台北市」這種簡寫）</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 台→臺（資料表上沒有「台北市」這種簡寫）</div></td></tr>
<!-- diff cache key alWiki:diff::1.12:old-10152:rev-10153 -->
</table>
丁志仁
http://jendo.org/alWiki/index.php?title=%E5%85%AC%E4%BF%9D%E8%88%87%E5%8B%9E%E4%BF%9D%E8%B3%87%E6%96%99%E5%8C%AF%E5%85%A5&diff=10152&oldid=prev
丁志仁：/* 諸 SQL 指令 */
2026-05-10T03:43:58Z
<p><span dir="auto"><span class="autocomment">諸 SQL 指令</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">於 2026年5月10日 (日) 03:43 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l76" >行 76：</td>
<td colspan="2" class="diff-lineno">行 76：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」<br/>---------- 以 MySQL 腳本命令派 scode 給公保資料與勞保資料 ----------</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」<br/>---------- 以 MySQL 腳本命令派 scode 給公保資料與勞保資料 ----------</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># mysql -u root -p密碼 < /volume1/homes/adminNas/www/wiki.sql</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># <ins class="diffchange diffchange-inline">/usr/local/mariadb10/bin/</ins>mysql -u root -p密碼 < /volume1/homes/adminNas/www/wiki.sql</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====待批次處理：====</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====待批次處理：====</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 台→臺（資料表上沒有「台北市」這種簡寫）</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 台→臺（資料表上沒有「台北市」這種簡寫）</div></td></tr>
</table>
丁志仁
http://jendo.org/alWiki/index.php?title=%E5%85%AC%E4%BF%9D%E8%88%87%E5%8B%9E%E4%BF%9D%E8%B3%87%E6%96%99%E5%8C%AF%E5%85%A5&diff=10151&oldid=prev
丁志仁：/* 諸 SQL 指令 */
2026-05-10T03:00:01Z
<p><span dir="auto"><span class="autocomment">諸 SQL 指令</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">於 2026年5月10日 (日) 03:00 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l53" >行 53：</td>
<td colspan="2" class="diff-lineno">行 53：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===諸 SQL 指令===</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===諸 SQL 指令===</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>::---------- 以 adminer 賦學校 schoolCode(簡稱 scode) ----------</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>::---------- 以 adminer 賦學校 schoolCode(簡稱 scode) ----------</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"># [[zhtwwikipedia::學校代碼|中華民國教育體系的學校識別碼]]</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 取公保校名：「select DISTINCT 學校名稱 from 2025公保資料;」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 取公保校名：「select DISTINCT 學校名稱 from 2025公保資料;」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 匯入公保校名得 3,520 校</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 匯入公保校名得 3,520 校</div></td></tr>
<!-- diff cache key alWiki:diff::1.12:old-10150:rev-10151 -->
</table>
丁志仁
http://jendo.org/alWiki/index.php?title=%E5%85%AC%E4%BF%9D%E8%88%87%E5%8B%9E%E4%BF%9D%E8%B3%87%E6%96%99%E5%8C%AF%E5%85%A5&diff=10150&oldid=prev
丁志仁：/* 諸 SQL 指令 */
2026-05-10T02:52:19Z
<p><span dir="auto"><span class="autocomment">諸 SQL 指令</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">於 2026年5月10日 (日) 02:52 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l52" >行 52：</td>
<td colspan="2" class="diff-lineno">行 52：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===諸 SQL 指令===</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===諸 SQL 指令===</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>:---------- 以 adminer 賦學校 schoolCode(簡稱 scode) ----------</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">:</ins>:---------- 以 adminer 賦學校 schoolCode(簡稱 scode) ----------</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 取公保校名：「select DISTINCT 學校名稱 from 2025公保資料;」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 取公保校名：「select DISTINCT 學校名稱 from 2025公保資料;」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 匯入公保校名得 3,520 校</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 匯入公保校名得 3,520 校</div></td></tr>
</table>
丁志仁
http://jendo.org/alWiki/index.php?title=%E5%85%AC%E4%BF%9D%E8%88%87%E5%8B%9E%E4%BF%9D%E8%B3%87%E6%96%99%E5%8C%AF%E5%85%A5&diff=10149&oldid=prev
丁志仁：/* 諸 SQL 指令 */
2026-05-10T02:51:50Z
<p><span dir="auto"><span class="autocomment">諸 SQL 指令</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">於 2026年5月10日 (日) 02:51 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l52" >行 52：</td>
<td colspan="2" class="diff-lineno">行 52：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===諸 SQL 指令===</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===諸 SQL 指令===</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">:---------- 以 adminer 賦學校 schoolCode(簡稱 scode) ----------</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 取公保校名：「select DISTINCT 學校名稱 from 2025公保資料;」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 取公保校名：「select DISTINCT 學校名稱 from 2025公保資料;」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 匯入公保校名得 3,520 校</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 匯入公保校名得 3,520 校</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l73" >行 73：</td>
<td colspan="2" class="diff-lineno">行 74：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從公保校名抄「UPDATE 2025勞保校名 a left join 2025公保校名 b using(原始校名) set a.schoolCode=b.schoolCode where a.schoolCode='' && b.schoolCode is not null」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從公保校名抄「UPDATE 2025勞保校名 a left join 2025公保校名 b using(原始校名) set a.schoolCode=b.schoolCode where a.schoolCode='' && b.schoolCode is not null」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」<ins class="diffchange diffchange-inline"><br/>---------- 以 MySQL 腳本命令派 scode 給公保資料與勞保資料 ----------</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"># mysql -u root -p密碼 < /volume1/homes/adminNas/www/wiki.sql</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====待批次處理：====</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====待批次處理：====</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 台→臺（資料表上沒有「台北市」這種簡寫）</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 台→臺（資料表上沒有「台北市」這種簡寫）</div></td></tr>
</table>
丁志仁
http://jendo.org/alWiki/index.php?title=%E5%85%AC%E4%BF%9D%E8%88%87%E5%8B%9E%E4%BF%9D%E8%B3%87%E6%96%99%E5%8C%AF%E5%85%A5&diff=10140&oldid=prev
丁志仁：/* 諸 SQL 指令 */
2026-05-09T07:34:48Z
<p><span dir="auto"><span class="autocomment">諸 SQL 指令</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">於 2026年5月9日 (六) 07:34 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l71" >行 71：</td>
<td colspan="2" class="diff-lineno">行 71：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立高中「UPDATE 2025勞保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中' && b.學校名稱 like '國立%' && a.schoolCode='' && b.schoolCode is not null」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立高中「UPDATE 2025勞保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中' && b.學校名稱 like '國立%' && a.schoolCode='' && b.schoolCode is not null」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立女中「UPDATE 2025勞保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'子高級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '國立%' && b.學校名稱 like '%女中' && a.schoolCode='' && b.schoolCode is not null」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立女中「UPDATE 2025勞保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'子高級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '國立%' && b.學校名稱 like '%女中' && a.schoolCode='' && b.schoolCode is not null」</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#*從公保校名抄「UPDATE 2025勞保校名 a left join 2025公保校名 b using(原始校名) set a.schoolCode=b.schoolCode where a.schoolCode='' && b.schoolCode is not null」</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」</div></td></tr>
</table>
丁志仁
http://jendo.org/alWiki/index.php?title=%E5%85%AC%E4%BF%9D%E8%88%87%E5%8B%9E%E4%BF%9D%E8%B3%87%E6%96%99%E5%8C%AF%E5%85%A5&diff=10139&oldid=prev
丁志仁：/* 諸 SQL 指令 */
2026-05-09T07:31:06Z
<p><span dir="auto"><span class="autocomment">諸 SQL 指令</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">於 2026年5月9日 (六) 07:31 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l65" >行 65：</td>
<td colspan="2" class="diff-lineno">行 65：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄 102 所縣市立高中，如「新北市立泰山高級中學」，「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(concat(SUBSTRING(縣市名稱,5,2),學校名稱),CHAR_LENGTH(concat(SUBSTRING(縣市名稱,5,2),學校名稱))-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中%'」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄 102 所縣市立高中，如「新北市立泰山高級中學」，「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(concat(SUBSTRING(縣市名稱,5,2),學校名稱),CHAR_LENGTH(concat(SUBSTRING(縣市名稱,5,2),學校名稱))-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中%'」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立高中「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中' && b.學校名稱 like '國立%' && a.schoolCode='' && b.schoolCode is not null」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立高中「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中' && b.學校名稱 like '國立%' && a.schoolCode='' && b.schoolCode is not null」</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#*#抄國立女中「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'子高級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '國立%' && b.學校名稱 like '%女中' && a.schoolCode='' && b.schoolCode is not null」</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 填 勞保校名 的 scode</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 填 勞保校名 的 scode</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從過往的檔案抄「update 2025勞保校名 a left join 2025postSchool b on a.原始校名=b.schoolName SET a.schoolCode=b.schoolCode where b.schoolName is not null」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從過往的檔案抄「update 2025勞保校名 a left join 2025postSchool b on a.原始校名=b.schoolName SET a.schoolCode=b.schoolCode where b.schoolName is not null」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從教育部編碼抄</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從教育部編碼抄</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立高中「UPDATE 2025勞保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中' && b.學校名稱 like '國立%' && a.schoolCode='' && b.schoolCode is not null」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄國立高中「UPDATE 2025勞保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中' && b.學校名稱 like '國立%' && a.schoolCode='' && b.schoolCode is not null」</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#*#抄國立女中「UPDATE 2025勞保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'子高級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '國立%' && b.學校名稱 like '%女中' && a.schoolCode='' && b.schoolCode is not null」</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」</div></td></tr>
</table>
丁志仁
http://jendo.org/alWiki/index.php?title=%E5%85%AC%E4%BF%9D%E8%88%87%E5%8B%9E%E4%BF%9D%E8%B3%87%E6%96%99%E5%8C%AF%E5%85%A5&diff=10138&oldid=prev
丁志仁：/* 諸 SQL 指令 */
2026-05-09T07:01:13Z
<p><span dir="auto"><span class="autocomment">諸 SQL 指令</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">於 2026年5月9日 (六) 07:01 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l64" >行 64：</td>
<td colspan="2" class="diff-lineno">行 64：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄校名相同者10所國立非大學「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=b.學校名稱 set a.schoolCode=b.schoolCode where a.schoolCode='' && b.schoolCode is not null」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄校名相同者10所國立非大學「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=b.學校名稱 set a.schoolCode=b.schoolCode where a.schoolCode='' && b.schoolCode is not null」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄 102 所縣市立高中，如「新北市立泰山高級中學」，「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(concat(SUBSTRING(縣市名稱,5,2),學校名稱),CHAR_LENGTH(concat(SUBSTRING(縣市名稱,5,2),學校名稱))-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中%'」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#抄 102 所縣市立高中，如「新北市立泰山高級中學」，「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(concat(SUBSTRING(縣市名稱,5,2),學校名稱),CHAR_LENGTH(concat(SUBSTRING(縣市名稱,5,2),學校名稱))-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中%'」</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#*#</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#*#<ins class="diffchange diffchange-inline">抄國立高中「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中' && b.學校名稱 like '國立%' && a.schoolCode='' && b.schoolCode is not null」</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># 填 勞保校名 的 scode <del class="diffchange diffchange-inline">「update </del>2025勞保校名 a left join 2025postSchool b on a.原始校名=b.schoolName SET a.schoolCode=b.schoolCode where b.schoolName is not null」</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># 填 勞保校名 的 scode</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#*從過往的檔案抄「update </ins>2025勞保校名 a left join 2025postSchool b on a.原始校名=b.schoolName SET a.schoolCode=b.schoolCode where b.schoolName <ins class="diffchange diffchange-inline">is not null」</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#*從教育部編碼抄</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#*#抄國立高中「UPDATE 2025勞保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(學校名稱,CHAR_LENGTH(學校名稱)-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中' && b.學校名稱 like '國立%' && a.schoolCode='' && b.schoolCode </ins>is not null」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 請恩濡用人工去補 2025公保校名 中 schoolCode 為空白的學校之 schoolCode</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 找可回收再用的頁「SELECT page_id,page_namespace,page_title,page_len FROM wiki_page WHERE page_namespace!=6 AND page_namespace!=14 ORDER BY page_len LIMIT 50」</div></td></tr>
</table>
丁志仁
http://jendo.org/alWiki/index.php?title=%E5%85%AC%E4%BF%9D%E8%88%87%E5%8B%9E%E4%BF%9D%E8%B3%87%E6%96%99%E5%8C%AF%E5%85%A5&diff=10137&oldid=prev
丁志仁：/* 諸 SQL 指令 */
2026-05-09T03:52:45Z
<p><span dir="auto"><span class="autocomment">諸 SQL 指令</span></span></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">於 2026年5月9日 (六) 03:52 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l62" >行 62：</td>
<td colspan="2" class="diff-lineno">行 62：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從過往的檔案抄「update 2025公保校名 a left join 2025postSchool b on a.原始校名=b.schoolName SET a.schoolCode=b.schoolCode where b.schoolName is not null」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從過往的檔案抄「update 2025公保校名 a left join 2025postSchool b on a.原始校名=b.schoolName SET a.schoolCode=b.schoolCode where b.schoolName is not null」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從教育部編碼抄</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*從教育部編碼抄</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#*#抄 102 <del class="diffchange diffchange-inline">縣市立高中，如「新北市立泰山高級中學」，「UPDATE </del>2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(concat(SUBSTRING(縣市名稱,5,2),學校名稱),CHAR_LENGTH(concat(SUBSTRING(縣市名稱,5,2),學校名稱))-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中%'」</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#*#抄校名相同者10所國立非大學「UPDATE 2025公保校名 a left join 2025學校代碼 b on a.原始校名=b.學校名稱 set a.schoolCode=b.schoolCode where a.schoolCode='' && b.schoolCode is not null」</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#*#抄 102 <ins class="diffchange diffchange-inline">所縣市立高中，如「新北市立泰山高級中學」，「UPDATE </ins>2025公保校名 a left join 2025學校代碼 b on a.原始校名=concat(LEFT(concat(SUBSTRING(縣市名稱,5,2),學校名稱),CHAR_LENGTH(concat(SUBSTRING(縣市名稱,5,2),學校名稱))-1),'級中學') set a.schoolCode=b.schoolCode where b.學校名稱 like '%高中%'」</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*#</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 填 勞保校名 的 scode 「update 2025勞保校名 a left join 2025postSchool b on a.原始校名=b.schoolName SET a.schoolCode=b.schoolCode where b.schoolName is not null」</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># 填 勞保校名 的 scode 「update 2025勞保校名 a left join 2025postSchool b on a.原始校名=b.schoolName SET a.schoolCode=b.schoolCode where b.schoolName is not null」</div></td></tr>
</table>
丁志仁