Python和MySQL交互

import pymysql

#都是连接数据库后，然后用游标cursor对数据进行操作
def databases_operations():
    # 建库建表
    try:
        # conn = pymysql.Connect(
        #     host='localhost',   # 调用函数时，输入参数不需要在等号”=“两边空格
        #     user='root',
        #     passwd='',
        #     charset='utf8'      #注意mysql中时utf8而不是utf-8
        # )
        # cur = conn.cursor()
        # create_database = 'create database demo1029'
        # result = cur.execute(create_database)

        conn = pymysql.Connect(
            host='localhost',
            user='root',
            passwd='',
            charset='utf8',
            db = 'demo1029',
        )
        cur = conn.cursor()

        # create_table = 'create table t1029(id int auto_increment primary key,name varchar(20))'
        # result = cur.execute(create_table)
        # print(result)

        insert_table = 'insert into t1029 values(1,"tzy"),(2,"twj")'
        result = cur.execute(insert_table)
        print(result)


    except Exception as e:
        print(e)


databases_operations()


def data_operations():
    # 1.连接数据库
    conn = pymysql.Connect(
        host='localhost',
        port=3306,
        db='animal',
        user='root',
        passwd="",
        charset='utf8'
    )

    #2 .数据操作
    try:
        # 创建游标对象
        cur = conn.cursor()

        # 3.1 插入数据
        # insert_sub = 'insert into course values(10,"go语言",NULL,3.5)'
        # result =cur.execute(insert_sub)
        # print(result)

        # 3.2 修改数据
        # update_sub = 'update course set cname = "区块链" where cno = 10'
        # result = cur.execute(update_sub)
        # print(result)

        # 3.3 删除数据
        # delete_sub = 'delete from course where cno = 10'
        # result = cur.execute(delete_sub)

        # 3.4 查询数据
        search_sub = 'select * from course'
        cur.execute(search_sub)        # 这么执行是找到查找数据返回的个数
        # result = cur.fetchone()     # 使用fetchone/fetchall查询数据的时候，先要让游标用execute获取数据
        result = cur.fetchall()
        print(result)

        # 以下是套路流程操作
        # 提交事务
        conn.commit()
        # conn.rollback()       # 也可以是回滚操作
        # 关闭游标
        cur.close()
        # 关闭连接
        conn.close()
    except Exception as e:
        print(e)