pymysql库常见用法

目录

1  非查询类语句

1.1  增加

1.2  修改

1.3  删除 

2  查询类语句

pymysql是操作mysql的，我当前的版本是 1.0.2

我们下面会使用my_db_01中的users表做例子，下面是表的全部信息

1  非查询类语句

非查询类就是 增 删 改，这种不需要返回值的，我们简单做三个例子

1.1  增加

import pymysql

conn = pymysql.connect(
    host="127.0.0.1",
    user="root",
    password="12345678",
    database="my_db_01",
    charset="utf8")
cursor = conn.cursor()

sql = "insert into users (username,password) values ('林登万','123456')"
cursor.execute(sql)

conn.commit()
cursor.close()
conn.close()

1.2  修改

import pymysql

conn = pymysql.connect(
    host="127.0.0.1",
    user="root",
    password="12345678",
    database="my_db_01",
    charset="utf8")
cursor = conn.cursor()

sql = "update users set password=111111,status=1 where username='林登万'"
cursor.execute(sql)

conn.commit()
cursor.close()
conn.close()

1.3  删除 

import pymysql

conn = pymysql.connect(
    host="127.0.0.1",
    user="root",
    password="12345678",
    database="my_db_01",
    charset="utf8")
cursor = conn.cursor()

sql = "delete from users where username='林登万'"
cursor.execute(sql)

conn.commit()
cursor.close()
conn.close()

2  查询类语句

查询类是要看到返回值的，使用cursor.fetchall()接收一下就可以了

import pymysql

conn = pymysql.connect(
    host="127.0.0.1",
    user="root",
    password="12345678",
    database="my_db_01",
    charset="utf8")
cursor = conn.cursor()

sql = "SELECT * FROM my_db_01.users"
cursor.execute(sql)
datas = cursor.fetchall()
print(datas)

conn.commit()
cursor.close()
conn.close()