python3.6 mysql 教程_windows下面使用python3.6操作mysql 使用pymysql

# 在环境变量中加入pip.exe所在的目录

# 通常在C:\Users\xxx\AppData\Local\Programs\Python\Python36-32\Scripts

# 打开CMD命令行 进行安装

# C:\Users\xxx>pip install pymysql

# Collecting pymysql

#   Downloading PyMySQL-0.8.0-py2.py3-none-any.whl (83kB)

#     100% |████████████████████████████████| 92kB 3.2MB/s

# Installing collected packages: pymysql

# Successfully installed pymysql-0.8.0

或者直接在pycharm中安装 推荐这种方式 否则pycharm好像无法识别pymysql

import pymysql

# 连接数据库

# connect = pymysql.Connect(

#     host='localhost',

#     port=3306,

#     user='root',

#     passwd='123456',

#     db='demopython',

#     charset='utf8'

# )

connect = pymysql.Connect(

host='192.168.1.14',

port=3306,

user='dbuser',

passwd='xxxx!xxx',

db='testdb',

charset='utf8'

)

# 获取游标

cursor = connect.cursor()

#创建数据表

#cursor.execute("create table student(id int ,name varchar(20),class varchar(30),age varchar(10))")

#插入一条数据

#cursor.execute("insert into student values('1','Tom','3 year 2 class','9')")

#修改查询条件的数据

#cursor.execute("update student set class='3 year 1 class' where name = 'Tom'")

#删除查询条件的数据

#cur.execute("delete from student where age='9'")

#查询数据

row = cursor.execute("select * from student")

print(row)

print(cursor.fetchone())

cursor.close()

connect.commit()

connect.close()