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()