#添加的表结构字段分辨是 (Id,title,summary,visits,accountname,grabtime)
#其中id, an int self-increment primary key that does not need to operate on an ID when adding an operation
conn = Mysql.connector.connect (user= ' root ', password= ', database= ' newsdb ', host= ' 127.0.0.1 ', port= ' 3306 ')
cursor = Conn.cursor ()
#此处Sql语句必须指定添加的字段名称!!!!!
sql = "INSERT into News (Title,summary,visits,accountname,grabtime) VALUES (%s,%s,%s,%s,%s)"
Try
Cursor.executemany (Sql,newsobj_tupelist)
Except Exception as E:
Conn.rollback ()
Print ("Error executing mysql:%s:%s"% (SQL, E))
Conn.commit ()
Cursor.close ()
Conn.close ()
#批量添加数据,!!!!! Data format must be List[tuple (), tuple (), tuple ()] or tuple (tuple (), tuple (), tuple ())
List = [(' 666 ', ' 666 ', ' 666 ', ' 666 ', ' 666 '), (' 777 ', ' 222 ', ' 333 ', ' 444 ', ' 555 ')]
Weixindb = Operation_weixindb ()
Weixindb.insert_news (list)
Python MySQL curros.executemany batch add