<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="zh-Hant-TW">
	<id>http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=Mysql_connect%E6%94%B9%E5%AF%AB%E8%A8%88%E5%8A%83</id>
	<title>Mysql connect改寫計劃 - 修訂紀錄</title>
	<link rel="self" type="application/atom+xml" href="http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=Mysql_connect%E6%94%B9%E5%AF%AB%E8%A8%88%E5%8A%83"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=Mysql_connect%E6%94%B9%E5%AF%AB%E8%A8%88%E5%8A%83&amp;action=history"/>
	<updated>2026-11-16T22:12:49Z</updated>
	<subtitle>本 wiki 上此頁面的修訂紀錄</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=Mysql_connect%E6%94%B9%E5%AF%AB%E8%A8%88%E5%8A%83&amp;diff=1791&amp;oldid=prev</id>
		<title>Root：​新頁面: ==importMark_mysql.php== &lt;SQL&gt; UPDATE      MARKTAG  SET TD016=B.TD016, TC012=B.TC012 FROM  MARKTAG A JOIN      (SELECT TD001,TD002,TD003,TD016,(select CASE WHEN X.UDF02 =&#039;&#039; THEN TC012...</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=Mysql_connect%E6%94%B9%E5%AF%AB%E8%A8%88%E5%8A%83&amp;diff=1791&amp;oldid=prev"/>
		<updated>2016-05-11T03:21:26Z</updated>

		<summary type="html">&lt;p&gt;新頁面: ==importMark_mysql.php== &amp;lt;SQL&amp;gt; UPDATE      MARKTAG  SET TD016=B.TD016, TC012=B.TC012 FROM  MARKTAG A JOIN      (SELECT TD001,TD002,TD003,TD016,(select CASE WHEN X.UDF02 =&amp;#039;&amp;#039; THEN TC012...&lt;/p&gt;
&lt;p&gt;&lt;b&gt;新頁面&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==importMark_mysql.php==&lt;br /&gt;
&amp;lt;SQL&amp;gt;&lt;br /&gt;
UPDATE  &lt;br /&gt;
   MARKTAG  SET TD016=B.TD016, TC012=B.TC012&lt;br /&gt;
FROM &lt;br /&gt;
MARKTAG A JOIN &lt;br /&gt;
    (SELECT TD001,TD002,TD003,TD016,(select CASE WHEN X.UDF02 =&amp;#039;&amp;#039; THEN TC012 ELSE X.UDF02 END) AS TC012&lt;br /&gt;
			FROM v_ORDER X JOIN INVMB ON TD004=INVMB.MB001 &lt;br /&gt;
			WHERE TD016&amp;lt;&amp;gt;&amp;#039;Y&amp;#039; AND MA002 LIKE &amp;#039;M%&amp;#039; AND TD001&amp;lt;&amp;gt;&amp;#039;2201&amp;#039;&lt;br /&gt;
			OR TD016&amp;lt;&amp;gt;&amp;#039;Y&amp;#039; AND MA002 LIKE &amp;#039;O%&amp;#039; AND TD004&amp;lt;&amp;gt;&amp;#039;32000001&amp;#039; AND TD001&amp;lt;&amp;gt;&amp;#039;2201&amp;#039;)B&lt;br /&gt;
ON A.TD001=B.TD001 AND A.TD002=B.TD002 AND A.TD003=B.TD003&lt;br /&gt;
&amp;lt;/SQL&amp;gt;&lt;/div&gt;</summary>
		<author><name>Root</name></author>
	</entry>
</feed>