pymysql的使用简单使用方法

最新推荐文章于 2024-07-18 00:00:00 发布

a599174211

最新推荐文章于 2024-07-18 00:00:00 发布

阅读量4.2k

点赞数 2

分类专栏： mysql Python

本文链接：https://blog.csdn.net/a599174211/article/details/82702219

版权

Python 同时被 2 个专栏收录

30 篇文章 2 订阅

订阅专栏

mysql

9 篇文章 0 订阅

订阅专栏

1.安装方法

pip安装：pip install PyMySQL

anaconda安装：conda install -c anaconda pymysql

2. pymysql执行流程

3.导入模块

from pymysql import *

4.实例

import pymysql
#连接数据库
db = pymysql.connect(host = 'localhost', user = 'root', password = 'password', db = 'demo1', port = 3306)
print(db)
cur = db.cursor()
sql = "select * from login where id = {}".format(1)
print(sql)
try :
    #查询
    cur.execute(sql)
    #查询所有数据
    results = cur.fetchall()
    #获取单条数据
    # results = cur.fetchone()
    for i  in results :
        id = i[0]
        username = i[1]
        passwrod = i[2]
        print('id:{},username:{},password:{}'.format(id, username, passwrod))

    #添加数据
    sql_insert = "insert into login(username,password) values ({},{})".format('"xiaowamg33"',666)
    print('sql_insrt:{}'.format(sql_insert))
    id  = cur.execute(sql_insert)
    print('id:{}'.format(id))
    db.commit()

    #修改
    sql_update = 'update login set username = {} where id = {}'.format('"dagege"',1)
    id_update = cur.execute(sql_update)
    print('修改的行数:{}'.format(id_update))
    db.commit()

    #删除
    sql_delete = 'delete from login where id={}'.format(2)
    id_dedete = cur.execute(sql_delete)
    print('删除的行数:{}'.format(id_dedete))
    db.commit()
except Exception as e:
    print(e)
    db.rollback()
finally:
    db.close()