我要评论python开发过程中用到数据库无外乎mysql,mangodb,redis三种，三者数据库使用可能存在差异，但在一些基础的语句使用时都是大同小异的，这阶段学习了一些基础操作，记录下
add:
# -*- coding: utf-8 -*-
import mysqldb
try:
conn=mysqldb.connect(host='192.168.65.146',port=3306,db='student',user='root',passwd='toor',charset='utf8')
csl=conn.cursor()
count=csl.execute("insert into stu(stu_id,stu_name,stu_phone,stu_hometown) values('0003','kj','19564832601',河北)")
print(count)
conn.commit()
csl.close()
conn.close()
except exception as e:
print (e).delete:
# -*- coding:utf-8 -*-
import mysqldb
try:
conn=mysqldb.connect(host='192.168.65.146',port=3306,db='student',user='root',passwd='toor',charset='utf8')
cs1=conn.cursor()
count=cs1.execute("delete from stu where stu_id=4")
print(count)
conn.commit()
conn.close()
except exception as e:
print(e)update:
# -*- coding:utf-8 -*-
import mysqldb
try:
conn=mysqldb.connect(host='192.168.65.146',port=3306,db='student',user='root',passwd='toor',charset='utf8')
cs1=conn.cursor()
count=cs1.execute("update stu set stu_phone='10005954565' where stu_name='张良'")
print(count)
conn.commit()
conn.close()
except exception as e:
print(e)search:
# -*- coding: utf-8 -*-
import mysqldb
try:
conn=mysqldb.connect(host='192.168.65.146',port=3306,db='student',user='root',passwd='toor',charset='utf8')
cs1=conn.cursor()
#cs1.execute("select * from stu where stu_id=1")
#result=cs1.fetchone() 查询一行
cs1.execute("select * from stu")
result=cs1.fetchall()#查询全部
print(result)
cs1.close()
conn.close()
except exception as e:
print(e)您可能感兴趣的文章:
如您对本文有疑问或者有任何想说的，请点击进行留言回复，万千网友为您解惑！
网友评论