Home > Article > Backend Development > Detailed explanation of how Python reads MySQL database table data
This article mainly explains in detail how to read MySQL database table data in Python. It has certain reference value. Interested friends can refer to it
The example in this article shares the specific code for reading MySQL database table data in Python for your reference. The specific content is as follows
Environment: Python 3.6, Window 64bit
Purpose: From the MySQL database Read the target table data and process the
code:
# -*- coding: utf-8 -*- import pandas as pd import pymysql ## 加上字符集参数,防止中文乱码 dbconn=pymysql.connect( host="**********", database="kimbo", user="kimbo_test", password="******", port=3306, charset='utf8' ) #sql语句 sqlcmd="select col_name,col_type,col_desc from itf_datadic_dtl_d limit 10" #利用pandas 模块导入mysql数据 a=pd.read_sql(sqlcmd,dbconn) #取前5行数据 b=a.head() print(b) # 读取csv数据 # pd.read_csv() # 读取excel数据 #pd.read_excel() # 读取txt数据 #pd.read_table()
The result is as shown in the figure:
The above is the detailed content of Detailed explanation of how Python reads MySQL database table data. For more information, please follow other related articles on the PHP Chinese website!