python 操作数据库(mysql)
python 操作数据库(mysql)
1、安装插件网上很多不在啰嗦。2、连接数据库后创建一个表
MySQLdb
conn = MySQLdb.connect(
=,
=,
=,
=,
=,
)
cur = conn.cursor()
cur.execute()
wKioL1ZO-0HjHFVZAAAaKB1VhV8560.png
3、增加一条数据
MySQLdb
conn = MySQLdb.connect(
=,
=,
=,
=,
=,
)
cur = conn.cursor()
cur.execute() #增
cur.close() #关闭游标
conn.commit() #提交数据(不提交是不能insert的语句不能出现)
conn.close() #关闭连接
wKioL1ZO_nOASXr8AAAhZ7CugMM247.png
4、删除一条数据
MySQLdb
conn = MySQLdb.connect(
=,
=,
=,
=,
=,
)
cur = conn.cursor()
cur.execute() cur.close()
conn.commit()
conn.close()
wKiom1ZPAWTzAed6AAAZsvlngOU103.png
5、修改一条数据
MySQLdb
conn = MySQLdb.connect(
=,
=,
=,
=,
=,
)
cur = conn.cursor()
cur.execute() cur.close()
conn.commit()
conn.close()
wKiom1ZPAtzy1pgwAABMB5Ktcm4814.png
6、查询数据
conn = .connect(
=,
=,
=,
=,
=,
)
cur = conn.cursor()
ll=cur.execute()
评论关闭