python链接数据库

1. https://blog.csdn.net/u010099177/article/details/93220251
   #首先先添加清华的镜像源
   conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/cloud/msys2/
   conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/cloud/conda-forge/
   conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/free/
   conda config --set show_channel_urls yes
   ————————————————
   原文链接：https://blog.csdn.net/ada0915/article/details/78529877

2. [0x7FFA6F01C250] ANOMALY: use of REX.w is meaningless (default operand size is 64)
   一直报这个错误，目前解决不了，先记下来吧，不影响使用

import pymysql
conn = pymysql.connect(
    host='localhost',
    user='root',
    passwd='填写自己的密码',
    db='pystudy',
    port=3306,
    charset='utf8')

1. cursor = conn.cursor()
   creat = ‘’’
   CREATE TABLE TEXT1(
   id int,
   name char(8),
   grade int
   )engine innodb default charset = utf8;’’’
   cursor.execute(creat)
   conn.commit()
2. from pandas import DataFrame
   import pymysql
3. conn = pymysql.connect(
   host = ‘localhost’,
   user = ‘root’,
   password = ‘986532aa’,
   db = ‘pystudy’,
   port = 3306,
   charset = ‘utf8’
   )
   cursor = conn.cursor()
   rows = cursor.execute(‘select * from ch4ex9’)
   rows
4. import pandas as pd
   df = pd.read_sql(‘select * from ch4ex9’,conn)
   df
5. data = cursor.fetchall()
6. df = DataFrame(list(data))
   df
7. df.to_sql(name=‘text1’,con=‘mysql+pymysql://root:986532aa@localhost:3306/pystudy?charset=utf8’,if_exists=‘replace’,index=False)