python操作mysql基础之分割与合并数据

# -*- coding: utf-8 -*-

import MySQLdb
conn = MySQLdb.connect(host='127.0.0.1',
                       user='root',
                       passwd='root',
                       db='cb',
                       port=3306,charset='utf8')
cur = conn.cursor()

goods = cur.execute("select goods_id,goods_nums from es_user_order" )
goods = cur.fetchmany(goods)
for glen in range(len(goods)):
    x = (goods[glen])[0]
    y = (goods[glen])[1]
    x = x.split(',')
    y = y.split(',')
    for i in range(len(x)):
        goodsId = x[i]
        saleNo = y[i]
        sql = "INSERT INTO sale (goods_id,sale) VALUES (%s,%s)"
        cur.execute(sql,(goodsId,saleNo))

cur.close
conn.commit()
conn.close

 

转载于:https://www.cnblogs.com/codebank/p/3662489.html