Python如何读取MySQL数据库表数据

# coding:utf-8
# author: zay
# 连接数据库
 
import pandas as pd
import pymysql
 
# 连接数据库
db = pymysql.connect(
    host = "localhost",
    database = "travel",
    user = "root",
    password = "xxxx",
    port = 3306,
    charset = 'utf8'
)
 
#sql语句
sqlcmd = "select commid,score,content from review"
 
#利用pandas 模块导入mysql数据
a=pd.read_sql(sqlcmd,db)
#取前5行数据
b=a.head()
print(b)
 
 
 
# 读取csv数据
# pd.read_csv()
 
# 读取excel数据
#pd.read_excel()
 
# 读取txt数据
#pd.read_table()