python批量插入数据到mysql数据库

1.本文档提供批量插入数据到mysql示例,以下是一条sql语句一次插入两行数据到mysql

2.关键代码

2.1 定义变量

conn = pymysql.connect(host='192.90.5.13', port=3306, user='root', passwd='root123', db='test')
cur = conn.cursor()

    colume = ['USR_NBR','STAT_MO','GPRS_FLUX','month']

    table = 'TW_NB_GPRS_BUSI_M'

          # keys = USR_NBR,STAT_MO,GPRS_FLUX,month
    keys = ','.join(i for i in colume)

            # values = %s,%s,%s,%s
    values = ','.join(['%s'] * len(colume))

2.2 定义插入语句
     insert_sql = 'insert into {table} ({keys}) VALUES ({values})'.format(table=table,keys=keys,values=values)

     ##输出结果：insert into T