python读取文件a写入到文件b中（TXT）

file = open('a.txt','r')
for i in file:
	a = i.split(',')[0]
	b = i.split(',')[1].rstrip('\n')
	file2 = open('d.txt','a')
	c = "UPDATE t SET t.a=a WHERE t.b ='%s';\n" % (a,b)
	file2.write(c)
	file2.close()
file.close()