Python第三方库【pymysql】导入mql文件

AI_茗

于 2024-07-21 22:30:06 发布

阅读量17

点赞数 1

文章标签： python 数据库 mysql 服务器

本文链接：https://blog.csdn.net/m0_71212744/article/details/140595253

版权

import pymysql

if __name__ == '__main__':
    connect = pymysql.connect(host='master', user='root', password='123456', database='stu', port=3306)
    cursor = connect.cursor()

    # 新建查询
    query_sql = 'select * from student'
    cursor.execute(query_sql)
    connect.commit()
    # 执行后提交

    # 变量插入
    name = 'zhangsan'
    age = 21
    # 第一种写法 以python字符串来写
    query_sql = 'insert into account values("%s",%d)' % (name, age)
    print(query_sql)
    cursor.execute(query_sql)
    connect.commit()
    # 第二种写法 主要体现在execute里
    query_sql = 'insert into account values(%s,%s)'
    print(query_sql)
    cursor.execute(query_sql, (name, age))
    connect.commit()
    # 一次性插入多条数据
    ls = [('wang', 21), ('zou', 18)]
    cursor.executemany(query_sql, ls)
    connect.commit()

    print(cursor.fetchone())
    print(cursor.fetchmany(10))
    print(cursor.fetchall())

    cursor.close()
    connect.close()