Python操作Mysql数据库
import pymysql import pymysql.cursors # 连接MySQL数据库Y connection = pymysql.connect(host='181.31.85.26', user='joyuser', port=3306, passwd='joypawd', db='JOY_HOME', charset='utf8mb4', cursorclass=pymysql.cursors.DictCursor) try: # 通过cursor创建游标 cursor = connection.cursor() # 创建sql 语句 sql = "select * from JOY_USER where NICKNAME = 'JOY'" # 执行sql语句 cursor.execute(sql) # 获取所有记录列表 results = cursor.fetchall() # print(results) for data in results: # 打印结果 print(data) except Exception:print("查询失败") cursor.close() # 关闭游标连接 connection.close() # 关闭数据库连接