python_sql

import pymssql
#如果是linux系统建议用sudo apt-get install freetds-dev更新一下

conn = pymssql.connect(host='10.12.60.34', user='sa', password='h3c.com!',database='cloudos')

# 如果和本机数据库交互，只需修改链接字符串
# conn=pymssql.connect(host='.',database='cloudos')

cur = conn.cursor()

cur.execute('SELECT * FROM dbo.vm_infor')

print(cur.fetchall())
cur.close()
conn.close()

truncate TABLE vm_infor;#清空表数据，但是不删除定义

 

　　

转载于:https://www.cnblogs.com/Bingo0-python/p/7692643.html