python 操作mysql

连接数据库
pip3 install ipython

>from pymysql import connect
>conn = connect(host=localhost', port=3306, user='root', password='root', database='db_name', charset='utf8')
>cursor = conn.cursor()
>cursor.execute("select * from import tb_name;")
>cursor.fetchone()
>cursor.fetchmany(2)
>cursor.close()
>conn.close()