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;#清空表数据,但是不删除定义