python插入数据库Mysql 关键字段

来源:互联网 发布:苹果跑分软件 编辑:程序博客网 时间:2024/05/29 03:26
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()
阅读全文
0 0
原创粉丝点击