安装
pip install PyMySQL
查表
import pymysql
dbconn = pymysql.connect(
host="localhost",
database="XXX",
user="root",
password="XXX+",
port=6666,
charset='utf8'
)
data = pd.read_sql('SELECT col1, col2, col3 FROM TABLE WHERE XXX', dbconn)
更新表
from pymysql import *
def main():
conn = connect(host='', port=3306, database='', user='',
password='', charset='utf8')
cs1 = conn.cursor()
query = "update 表名 set 字段1 = 值1 where 字段2 = '{}'".format(值2)
cs1.execute(query)
conn.commit()
cs1.close()
conn.close()
if __name__ == '__main__':
main()