data=“‘sd’,’sd’”
cursor.execute(‘insert into py_dict (code,name) values (%s)’%data)
insert into py_dict (code,name) values (s%,s%),(‘sql’,’sql’)
操作多条数据:
tt = [(‘fdf’,’gdf’),(‘fdf’,’gdf’)]
cursor.executemany(‘insert into py_dict (code,name) values (%s,%s)’,tt)