python pymysql存储

# _*_ coding:utf-8 _*_
import requests
from bs4 import BeautifulSoup
import re
import pymysql

def create():
    db = pymysql.connect("localhost", "root", "111111", "aoyang")  # 连接数据库
    cursor = db.cursor()
    cursor.execute("DROP TABLE IF EXISTS aoy")#查询是否有相同的表，如果有删除，重新建表
    sql = """CREATE TABLE `aoy` (
`id`  int(10) NOT NULL AUTO_INCREMENT ,
`name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`Price`  decimal(10,2) NULL DEFAULT NULL ,
`spec`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`Manufactor`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)"""
    cursor.execute(sql)
    db.close()

def insert(value):
    db = pymysql.connect("127.0.0.1", "root", "111111", "aoyang")
    cursor = db.cursor()
    sql = "INSERT INTO aoy(name,Price,spec,Manufactor) VALUES (%s, %s, %s, %s)"
    try:
        cursor.execute(sql, value)
        db.commit()
        print('插入数据成功')
    except:
        db.rollback()
        print("插入数据失败")
    #cursor.execute(sql, value)
    #db.commit()
    db.close()


def aa():
    ddd = '哈'
    i = [ddd, '22.22', 'kkk','方法']
    q = ['sdasdas', '22.22', 'kkk','问']

    insert(q)

    insert(i)
create()
aa()