Python 连接MySQL的操作

python2中需要导入MySQLdb模块，python3中需要导入pymysql模块

# coding=utf-8
__date__ = '2019/9/12 10:24'
__author__ = 'Allen'

import pymysql


class OperationMysql:
    def __init__(self):
        self.conn = pymysql.connect(
            host='localhost',
            port=3306,
            user='root',
            password='enteo$1',
            db='allentest',
            charset='utf8',
        )
        self.cur = self.conn.cursor()

    # 查询一条数据
    def search_one(self, sql):
        self.cur.execute(sql)
        result = self.cur.fetchone()
        return result


if __name__ == '__main__':
    op_mysql = OperationMysql()
    print(op_mysql.search_one("select * from person where age=22"))

结果：

 

如果要连表中字段名一起打印出来，则要导入pymysql.cursors

# coding=utf-8
__date__ = '2019/9/12 10:58'
__author__ = 'Allen'

import pymysql.cursors

conn = pymysql.connect(
            host='localhost',
            port=3306,
            user='root',
            password='enteo$1',
            db='allentest',
            charset='utf8',
            cursorclass=pymysql.cursors.DictCursor      # 最终结果带字段名
        )
cur = conn.cursor()
cur.execute("select * from person where age=22")
print(cur.fetchone())

结果：