Python远程连接mysql和sqlserver数据库
1.mysql
import pymysql
conn = pymysql.Connect(
host='填写数据库名',
port=3306,
user='填写用户名',
passwd='填写密码',
db='具体的库名(子目录)',
charset='utf8'
)
print (conn)
print (type(conn))
cursor = conn.cursor()
sql = "select * from 表名;"
row_count = cursor.execute(sql)
print("SQL 语句执行影响的行数%d" % row_count)
for line in cursor.fetchall():
print(line)
cursor.close()
conn.close()
2.sqlserver
import pymssql
conn = pymssql.connect(server = "数据库名" , database = "具体的库名(子目录)")
cursor = conn.cursor()
sql = "SELECT top 10 * FROM 表名"
row_count = cursor.execute(sql)
for line in cursor.fetchall():
print(line)
cursor.close()
conn.close()