python操作MySQL

最新推荐文章于 2024-05-19 15:51:39 发布

liuxiangke0210

最新推荐文章于 2024-05-19 15:51:39 发布

阅读量116

点赞数

分类专栏： python

本文链接：https://blog.csdn.net/liuxiangke0210/article/details/79819561

版权

python 专栏收录该内容

34 篇文章 0 订阅

订阅专栏

实现需要有有驱动包通过包管理下载

mysql.connector

实例代码

#!/usr/bin/env/ python
# -*- coding: utf-8 -*-
""" 
@author:Administrator 
@file: MySql.py 
@time: 2018/04/04 
"""
import mysql.connector

conn = mysql.connector.connect(user='root',password='root',database='test')
cursor = conn.cursor()
try:
    cursor.execute('select * from school')
    results = cursor.fetchall()
    for row in results:
        uuid = row[0]
        school = row[1]
        province = row[2]
        print('uuid :%s ,school:%s , province :%s'%(uuid , school , province))
except Exception as e:
    print('error: unable to fecth data')
finally:
    cursor.close()