标签：insert mysql 插入 template sql new python2 data row
insert_sql_template = """
insert into ap_console_template (`id`, `name`, `type`, `content`, `desc`) values (%s, '%s', %s, '%s', '%s')
"""
for row_data in all_data:
new_row = []
for i in row_data:
print(i, type(i))
if isinstance(i, unicode):
i = i.encode("utf-8")
new_row.append(i)
insert_sql = insert_sql_template % tuple(new_row)
cur.execute(insert_sql)
标签：insert,
mysql,
插入,
template,
sql,
new,
python2,
data,
row
From： https://www.cnblogs.com/zhang-can/p/16984694.html