def save_to_mytsql(result):
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=localhost;DATABASE=test;UID=sa;PWD=123456')
cur = conn.cursor()
sql='insert into toutiao([title],[url], [images]) values(?,?,?)'
cur.execute(sql,(result['title'], result['url'], str(result['images'])))
conn.commit()
conn.close()
存入值不能为list 要是string
python用pyodbc存入SQL SEVER
最新推荐文章于 2024-07-26 02:30:00 发布