Python批量插入数据到mysql中，相较于jdbc，简化了长度。
占位符使用的%s而不是?
import mysql.connector as conn def __getConn(): db = conn.connect( host="localhost", user="root", passwd="root", database="test" ) return db def insertBatch(db): cur = db.cursor() # 不需要像jdbc那样在value后面写多个 sql = "insert into t_dict2 (parent_code,code) values (%s,%s)" val = [("zhangsan11","test11"),("zhangsan21","test21"),("zhangsan31","test31")] cur.executemany(sql, val) pass if __name__ == "__main__": db = __getConn() insertBatch(db) db.commit()
