Python reads MySQL database table data

• Environment

Python 3.6, Window 64bit

• Objective

Reads the target table data from the MySQL database and processes

• Code

#-*-Coding:utf-8-*-import pandas as Pdimport pymysql## plus character set parameters to prevent Chinese garbled dbconn=pymysql.connect (    host= "**********",    database= "Kimbo",    user= "Kimbo_test",    password= "******",    port=3306,    charset= ' UTF8 ') # SQL statement sqlcmd= "Select Col_name,col_type,col_desc from Itf_datadic_dtl_d limit" #利用pandas module to import MySQL data a=pd.read_sql ( Sqlcmd,dbconn) #取前5行数据b =a.head () print (b) # read CSV data # pd.read_csv () # Read Excel Data #pd.read_excel () # Read TXT data #pd.read_table ( )

Results

　　

Python reads MySQL database table data