pycharm和mysql交互,量化投资 mysql与pycharm 交互

简单修改一个数据，了解mysql 与 pycharm 交互过程

# 1、导入pymysql模块

import pymysql

#主程序入口

if __name__ == '__main__':

# 2、创建连接对象

conn = pymysql.connect(host='localhost',

port=3306,

user='root',

password='root',

database='sanguo',

charset='utf8')

try:

# 3、获取游标目的要执行SQL

cursor = conn.cursor()

# 4、查询并打印SQL语句

sql = "update sanguo set country= '蜀' where id = 10"

#执行sql

row_count = cursor.execute(sql)

print("SQL语句执行影响的行数%d" % row_count)

#提交给sql

conn.commit()

except Exception as e:

#回滚数据，即撤销刚刚的SQL语句操作

conn.rollback()

# 5、关闭游标

cursor.close()

# 6、关闭连接

conn.close()