´úÂëÈçÏ£º
import os
import time
source = [r'e:\python',r'e:\temp']
#print(source)
print('Ô´£º')
for spath in source:
print(spath)
target_dir = r'e:\bak'
print('\nÄ¿µÄµØ£º')
print(target_dir)
target = time.str ......
#½«GB2312¸ñʽתΪUTF-8¸ñʽ
f = codecs.open('e:\TestResult.xml', "rb", "gb2312")
text = f.read().encode("utf-8")
f.close
f = open(options.TestResultFile, "wb")
......
ÏëʵÏÖ ´ÓÎı¾Îļþµ¼Èëµ½AccessÒѾ¶¨ÒåºÃµÄ±í£¬
Îı¾ÎļþÄÚÈÝÊÇ£º
id1,value11, value12,value13
id2,value21,value22,value23
±í×Ö¶Î
id, value0,value1,value2,value3,value4
ʵÏÖ°ÉÎı¾ÀïÃæµÄÄÚÈÝ£¬¶ÔӦÿ¸ö×Ö¶Î µ¼Èëµ½±íÀïÃæ£¬ÓÐûÓбȽϿìËٵķ½·¨¡£
Îı¾ÎļþÀïÃæÃ»ÓÐ ±íÍ·ÐÅ ......
ÓÐÁ½¸öÊý¾Ý±í TBL1 TBL2
TBL1
ÁÐ1 ÁÐ2
1 aa
2 bb
3 cc
TBL2
ÁÐ1 ÁÐ2 ÁÐ3
ÎÒÏë°ÑTBL1µÄÊý¾Ý¸´ÖƵ½TBL2
È»ºóÏòTBL2µÄ[ÁÐ3]Àï´úÈëNULL
ÇëÎÊÒÔÉϲÙ×÷ÓÃVBAÔõôʵÏÖ£¬Ð»Ð»ÁË
{{ ......
accessÊý¾Ý¿âÖв»µÈÓÚµÄÔËËã·ûÊÇʲô£¿
<>
.
SELECT a.id,a.ÐÕÃû,b.Ô±¹¤id from tblµ¥Î»ÈËÔ± as a inner join tblÔ±¹¤³öÇڼǼ±í as b on a.id <>b.Ô±¹¤id
Ò»ÔËÐÐÕâ¸ö¾Í³ÉΪËÀÑ»·ÁË
- -額
ÕæÊÇÒÉ難為題°¢
還²»¾ÍÊÇÄÇ幾個£¬£¬
ÄãÒ ......
±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½á¹û:
ÈÕÆÚ ÊýÁ¿
2010-01-09 0
2010-01-10 0
2010-01-11 1
2010-01-12 0
...
2010-02-09 ......