python基础知识(19)之MYSQL-MySQLdb

# coding=UTF8
"""
    create time:2022-11-18 14:42:40
    @Author    :wyk
"""
import MySQLdb  # 用原生 SQL 操作数据库

connect = MySQLdb.connect(
    host='localhost',  # 主机
    port=3306,  # 端口号
    user='root',  # 用户名
    passwd='******',  # 密码
    db='wyk',  # 数据库名称
    use_unicode=True,  # 指定字符的编、解码格式
    charset='utf8'
)

# 先获取游标，再进行相应 SQL 操作
cursor = connect.cursor()
# 执行新增 SQL
sql = 'insert into Student (name, age) values (%s, %s);'
data = [('e','30'), ('f', '31')]
cursor.executemany(sql, data)
# 提交
connect.commit()

# 执行查询SQL
sql2 = 'select * from Student'
cursor.execute(sql2)
print(cursor.fetchone())  # 获取结果集的下一行
print(cursor.fetchmany(2))  # 获取结果集的下几行
print(cursor.fetchall())  # 获取结果集中剩下的所有行

# 执行修改SQL
sql3 = "update Student set age = '12' where id = 1"
cursor.execute(sql3)
connect.commit()

# 执行删除SQL
sql4 = 'delete from Student where id = 1'
cursor.execute(sql4)
connect.commit()

# 关闭
cursor.close()
connect.close()