python pymysql存储

最新推荐文章于 2025-02-03 00:31:58 发布

转载最新推荐文章于 2025-02-03 00:31:58 发布 · 171 阅读

1 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/ymkdxw/p/10436865.html

文章标签：

#python #数据库

本文详细介绍了使用Python连接并操作MySQL数据库的方法，包括创建表、插入数据等关键步骤，适用于初学者快速上手。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 1 # _*_ coding:utf-8 _*_
 2 import requests
 3 from bs4 import BeautifulSoup
 4 import re
 5 import pymysql
 6 
 7 def create():
 8     db = pymysql.connect("localhost", "root", "111111", "aoyang")  # 连接数据库
 9     cursor = db.cursor()
10     cursor.execute("DROP TABLE IF EXISTS aoy")#查询是否有相同的表，如果有删除，重新建表
11     sql = """CREATE TABLE `aoy` (
12 `id`  int(10) NOT NULL AUTO_INCREMENT ,
13 `name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
14 `Price`  decimal(10,2) NULL DEFAULT NULL ,
15 `spec`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
16 `Manufactor`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
17 PRIMARY KEY (`id`)
18 )"""
19     cursor.execute(sql)
20     db.close()
21 
22 def insert(value):
23     db = pymysql.connect("127.0.0.1", "root", "111111", "aoyang")
24     cursor = db.cursor()
25     sql = "INSERT INTO aoy(name,Price,spec,Manufactor) VALUES (%s, %s, %s, %s)"
26     try:
27         cursor.execute(sql, value)
28         db.commit()
29         print('插入数据成功')
30     except:
31         db.rollback()
32         print("插入数据失败")
33     #cursor.execute(sql, value)
34     #db.commit()
35     db.close()
36 
37 
38 def aa():
39     ddd = '哈'
40     i = [ddd, '22.22', 'kkk','方法']
41     q = ['sdasdas', '22.22', 'kkk','问']
42 
43     insert(q)
44 
45     insert(i)
46 create()
47 aa()