Home  >  Article  >  Backend Development  >  Detailed explanation of how Python reads MySQL database table data

Detailed explanation of how Python reads MySQL database table data

高洛峰
高洛峰Original
2017-03-13 09:46:373025browse

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:

Detailed explanation of how Python reads MySQL database table data

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn