链接数据库-python

C:\Users\Administrator\AppData\Local\Programs\Python\Python36-32\Scripts

#打开python文件目录，复制路径到，计算机属性环境变量path里面粘贴进去

打开cmd

pip install pymysql

#安装mysql

-----------------------------------------------------------------------------

import pymysql

#引入模块

conn = pymysql.connect(host='10.32.24.94', port=3306,user='wanyang', passwd='123456', db='wanyang')

#写链接数据库字符串

cur = conn.cursor()

#接受返回值方法

cur.execute("select * from tb_student")

#执行sql语句

for r in cur.fetchall():

#取结果集剩下几行（通常查询所有）

    print(r)

cur.close()

cur.close()

------------------------------------------------------------------------------------------------