import MySQLdb
conn=MySQLdb.connect(host="localhost",user="root",passwd="19900410w",port=3306,db="crawl")
cur=conn.cursor()
sql="insert into proxy_avi values(%s,%s)"
# sql="show tables"
# sql="select * from proxy_avi"
ip_port=[["120.25.171.183","8080"],["120.25.171.183","8081"]]
cur.executemany(sql,ip_port)
conn.commit()
cur.close()
conn.close()
python mysql 插入
最新推荐文章于 2024-05-29 10:40:35 发布