PyMySQL的使用(增删改查)

原创已于 2024-02-17 21:46:04 修改 · 912 阅读

8 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #mysql #python

于 2024-02-17 03:39:28 首次发布

Python 同时被 2 个专栏收录

25 篇文章

订阅专栏

Database

19 篇文章

订阅专栏

文章详细介绍了如何使用pymysql库在Python中连接MySQL数据库，包括查询、插入、更新和删除数据的基本操作。通过示例展示了创建连接、执行SQL语句、处理事务以及关闭连接的过程。

1.pymysql查询数据库数据

#1.导包
import pymysql

if __name__ == '__main__':
    #2.创建连接对象
    conn = pymysql.connect(
        host = "localhost",
        port=3306,
        user="root",
        password = "mysql",
        database = "python11",
        charset = "utf8")
    #3.获取游标，目的是执行sql语句
    cursor = conn.cursor()
    #4.执行sql语句
    sql = "select * from students;"
    cursor.execute(sql)
    # 获取一条数据
    # row = cursor.fetchone()
    # print(row)
    # 获取所有数据
    alluser  = cursor.fetchall()
    print(alluser)
    for row in alluser:
        print(row)
    #5.关闭游标
    cursor.close()
    #6.关闭连接
    conn.close()

2.pymysql增删改数据库数据

#1.导包
import pymysql

if __name__ == '__main__':
    #2.创建连接对象
    conn = pymysql.connect(
        host = "localhost",
        port=3306,
        user="root",
        password = "mysql",
        database = "python11",
        charset = "utf8")
    #3.获取游标，目的是执行sql语句
    cursor = conn.cursor()
    #4.执行sql语句
    # # 添加数据
    # sql = "insert into teacher(name) values('feifei');"
    # 修改数据
    # sql = "update teacher set name='fangfang' where id=4";
    # 删除数据
    sql = "delete from teacher where id=4;"
    try:
        cursor.execute(sql)
        conn.commit()
    except Exception as e:
        conn.rollback()
    finally:
        #5.关闭游标
        cursor.close()
        #6.关闭连接
        conn.close()