首页 > 数据库技术 > 详细

寒假学习进度-6(Python连接MySQL数据库)

时间:2020-02-03 11:10:43      阅读:70      评论:0      收藏:0      [点我收藏+]

Python连接mysql和操作

软件:pycharm

开始在pycharm下面的Terminal中安装mysql时提醒pip版本不够,所以需要先升级一下pip

python -m pip install --upgrade pip

升级完pip之后就可以下载mysql

pip install mysql

下载完成后在setting中查看

技术分享图片

进行代码测试

#!/usr/bin/python
# -*- coding: UTF-8 -*-

import MySQLdb
db =MySQLdb.connect("localhost","root","liu123","test",charset=‘utf8‘)
cursor=db.cursor()
cursor.execute("SELECT VERSION()")
data=cursor.fetchone()
print ("Database version : %s" % data)
db.colse()
Database version : 5.7.10-log

插入

#!/usr/bin/python
# -*- coding: UTF-8 -*-

import MySQLdb
db =MySQLdb.connect("localhost","root","liu123","test",charset=‘utf8‘)
cursor=db.cursor()
sql="insert into admin(account,passwd) values (‘abc‘,‘123456789‘)"
try:
    cursor.execute(sql)
    db.commit()
except:
    db.rollback()
db.close()

查找

#!/usr/bin/python
# -*- coding: UTF-8 -*-

import MySQLdb
db =MySQLdb.connect("localhost","root","liu123","test",charset=‘utf8‘)
cursor=db.cursor()
sql="select * from admin"
try:
    cursor.execute(sql)
    results=cursor.fetchall()
    for row in results:
        account=row[0]
        password=row[1]
        print("account=%s,password=%s" % (account,password))
except:
    print("Error:unable to fetch data")
db.close()

更新

#!/usr/bin/python
# -*- coding: UTF-8 -*-

import MySQLdb
db =MySQLdb.connect("localhost","root","liu123","test",charset=‘utf8‘)
cursor=db.cursor()
sql="update admin set passwd = 987654321 where account =‘root‘"
try:
    cursor.execute(sql)
    db.commit()
except:
    db.rollback()
db.close()

删除

#!/usr/bin/python
# -*- coding: UTF-8 -*-

import MySQLdb
db =MySQLdb.connect("localhost","root","liu123","test",charset=‘utf8‘)
cursor=db.cursor()
sql="delete from admin where account =‘root‘"
try:
    cursor.execute(sql)
    db.commit()
except:
    db.rollback()
db.close()

 

寒假学习进度-6(Python连接MySQL数据库)

原文:https://www.cnblogs.com/liujinxin123/p/12254784.html

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