使用Pycharm操作MySql数据库

# -- coding: utf-8 --
import pymysql

def load_all_from_mysql():
    connect = pymysql.Connect(
        host = ‘localhost‘,
        port = 3306,
        user = ‘root‘,
        password = ‘******‘,
        db = ‘数据库名‘,
        charset = ‘utf8‘
    )
    cursor = connect.cursor()
    sql = "SELECT * from 表名"
    cursor.execute(sql)
    # print(cursor.fetchall())
    for row in cursor.fetchall():
        print(row)

load_all_from_mysql()