首页 > 数据库技术 > 详细

Python对MYSQL数据库的操作

时间:2019-05-20 13:30:25      阅读:137      评论:0      收藏:0      [点我收藏+]

通过引入pymysql来操作数据库:

# -*- coding: UTF-8 -*-
import pymysql
import pymysql.cursors

connection = pymysql.connect(host='127.0.0.1',
                             user='root',
                             password='',
                             db='test',
                             port=3306,
                             charset='utf8')  # 注意是utf8不是utf-8
try:
    with connection.cursor() as cursor:
        sql_1 = 'select * from user'
        cout_1 = cursor.execute(sql_1)
        print("数量: " + str(cout_1))
        for row in cursor.fetchall():
            print("user_name:", str(row[0]), 'python_time', str(row[1]))

        sql_2 = 'insert into user(user_name,time) value("python_name","python_time")'
        cout_2 = cursor.execute(sql_2)
        print("数量: " + str(cout_2))
        connection.commit()
finally:
    connection.close()

Python对MYSQL数据库的操作

原文:https://www.cnblogs.com/nizuohao/p/10893619.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!