【Python】连接 Mysql

一 导包

import pandas as pd
import numpy as np
import pymysql

二 连接数据库

# 数据库名
databaseName="zdft" 
# 表名
tableName='mini'

conn=pymysql.connect(host='localhost',user='root',password='',port=3306,charset='utf8',database='zdft')
cursor = conn.cursor()

三 select方法

def Select():
    # SQL 查询语句
    sql = " SELECT * FROM {} ".format(tableName)
    try:
        # 执行SQL语句
        cursor.execute(sql)
        results = np.asarray(cursor.fetchall(),dtype='float64')
        results = results[:,1:]
        print('OK')
    except:
        print("Error: unable to fecth data")
    return results