python插入数据库Mysql 关键字段

最新推荐文章于 2022-12-14 14:53:32 发布

douyunqian668

最新推荐文章于 2022-12-14 14:53:32 发布

阅读量717

点赞数

分类专栏： Python高级编程

本文链接：https://blog.csdn.net/douyunqian668/article/details/78733773

版权

Python高级编程专栏收录该内容

107 篇文章 1 订阅

订阅专栏

INSERT_SQL = """
          insert into zt_bug (product,title,keywords,pri,hardware,steps,color,activatedCount,openedDate,openedBuild,assignedDate,deadline,resolvedDate,closedDate,duplicateBug,linkBug,result,testtask,lastEditedDate,openedBy,assignedTo,`case`)

values(8,'%s','errorcode',1,'auto_test','%s','red',0,'%s','trunk','%s','0000-00-00','0000-00-00','0000-00-00',0,'None',0,0,'0000-00-00 00:00:00','%s','%s',0);"""%(title,content,opendate,assigneddate,openedBy,assignedTo)
# logger.info(INSERT_SQL, title, content, opendata, assigneddate)
print(INSERT_SQL)
self.cursor.execute(INSERT_SQL)
self.conn.commit()