简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > Python Tutorial > body text

Python中让MySQL查询结果返回字典类型的方法

WBOY
Release： 2016-06-16 08:42:40
Original
1351 people have browsed it

Python的MySQLdb模块是Python连接MySQL的一个模块，默认查询结果返回是tuple类型，只能通过0,1..等索引下标访问数据
默认连接数据库：

复制代码 代码如下:

MySQLdb.connect(
    host=host,
        user=user,
        passwd=passwd,
        db=db,
        port=port,
        charset='utf8'
)
查询数据：
复制代码 代码如下:

cur = conn.cursor()
cur.execute('select b_id from blog limit 1')
data = cur.fetchall() 
cur.close()
conn.close()

打印：
复制代码 代码如下:

for row in data:
    print type(row)
    print row

执行结果：
复制代码 代码如下:


(1L,)

为tuple类型。
我们可以这么干使得数据查询结果返回字典类型，即 字段=数据
导入模块
复制代码 代码如下:

import MySQLdb.cursors
在连接函数里加上这个参数  cursorclass = MySQLdb.cursors.DictCursor 如：
复制代码 代码如下:

MySQLdb.connect(
    host=host,
        user=user,
        passwd=passwd,
        db=db,
        port=port,
        charset='utf8',
    cursorclass = MySQLdb.cursors.DictCursor
)
再重新运行脚本，看看执行结果：
复制代码 代码如下:


{'b_id': 1L}

搞定！
注意，在连接的时候port如果要指定则值必须是整型，否则会出错！
Related labels：
mysql python
source：php.cn
Previous article：Python利用pyHook实现监听用户鼠标与键盘事件 Next article：Python发送Email方法实例
Statement of this Website
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
Latest Articles by Author
Latest Issues
Python/MySQL cannot persist integer data correctly No code is required here. I want to save a very long number because I'm making a game and ...
From 2024-04-04 19:09:44
0
1
367
Using selenium want to click and define URL in class I need another tip today. I'm trying to build Python/Selenium code and the idea is to clic...
From 2024-04-04 14:14:44
0
1
3492
Selenium + Python - inspect image via execute_script I need to verify that an image is displayed on the page using selenium in python. For exam...
From 2024-04-03 09:32:15
0
1
375
How to keep the first X rows and delete table rows I have a big table with millions of records in MySQLincident_archive, I want to sort the r...
From 2024-04-01 18:32:54
0
1
347
How to scrape specific Google Weather text using BeautifulSoup? How to find the course text "New York City, USA" in Python using BeautifulSoup? ...
From 2024-04-01 14:06:14
0
1
308
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！