借助Python工具执行数据库SQL语句select

xupeng_ engineer

已于 2024-07-23 08:02:20 修改

阅读量74

点赞数 2

文章标签：数据库 python sql

于 2024-07-23 08:01:31 首次发布

本文链接：https://blog.csdn.net/u014379204/article/details/140624682

版权

# coding=utf-8
import paramiko
import mysql.connector
#
db_connection = mysql.connector.connect(
  user="admin",
  password="password",
  host="192.168.87.79",
  database="hosts_info"
)
#
cursor = db_connection.cursor()
#
# 执行查询语句
cursor.execute('SELECT * FROM host_tmp')

# 获取查询结果
result = cursor.fetchall()

# 处理查询结果
for row in result:
    print(row)

# 提交事务
db_connection.commit()

# 关闭游标和连接
cursor.close()
db_connection.close()