import pymysql
conn=pymysql.Connect(
host='localhost',
port=3306,
user='root',
passwd='12345',
database='database_MySQL',
charset='utf8',
)
cs=conn.cursor()
sql="update forum set content ='new content' where topic='t4'"
cs.execute(sql)
conn.commit()
cs.close()
conn.close()
# 创建cursor,默认返回元组形式的结果,这里采用字典的形式返回
cs = conn.cursor(cursor = pyMySQL.cursor.DictCursor)
# fetchall:
cs.execute('sql语句')
ret = cs.fetchall()
# fetchmany:
cs.execute('sql语句')
ret = cs.fetchmany(2)#在select语句中最后补上limit0,2是一样的效果
# fetchone:
cs.execute('sql语句')
ret = cs.fetchone()
sqlalchemy库比较支持 pandas操作数据库
from sqlalchemy import create_engine
conn = create_engine('mysql+pymysql://root:12345@localhost:3306/recom
mend?charset=utf8')
#格式mysql+pymysql://【用户名】:【密码】@【ip地址】:【端口】/【数据库】?charset=【编码】
读取数据库
from sqlalchemy import create_engine
import pandas as pd
conn = create_engine('mysql+pymysql://root:12345@localhost:3306/recommend?charset=utf8')
df_data = pd.read_sql('select * from 表',conn,)