python 列表输入sql_将Python列表格式化为SQL脚本？

我有一个列表需要格式化成SQL脚本list =

[['11', ' 0', " 'MMB'", " '2 MB INTERNATIONAL'", ' NULL', ' NULL', ' 0\n'],

['12', ' 0', " '3D STRUCTURES'", " '3D STRUCTURES'", ' NULL', ' NULL', ' 0\n'],

['13', ' 0', " '2 STRUCTURES'", " '2D STRUCTURES'", ' NULL', ' NULL', ' 0\n'],

sql脚本如下：

^{pr2}$

我已经试过了import pickle

import re

#RX = re.compile(r'^.*?\(\d+,\s0,.*\s0\)\s*$')

outfile = open('destination.sql', 'wb')

data = []

for ln in open('source.sql', 'r').xreadlines():

replace1 = ln.replace("INSERT INTO `Tbl_ABC` VALUES (", "")

replace2 = replace1.replace(")", "")

list_replace = replace2.split(',')

data.append(list_replace)

destinationdata = [d for d in data if d[1] == ' 0' and d[6]==' 0\n']#print '%s ,%s' % (list_replace[1], list_replace[6])

#start write line to destination.sql

#if RX.match(ln):

pickle.dump(destinationdata, outfile)

outfile.close()

谢谢你的帮助！在