概述
一、安装MysqL-python
conn = MysqLdb.connect(user='root',passwd='admin',host='127.0.0.1')
conn.select_db('test')
cur = conn.cursor()
def selectdb():
sql = 'select `name` from test where `sort` = "%s"'
exsql = sql % ('python')
count = cur.execute(exsql)
for row in cur:
print row
print 'cursor move to top:'
cur.scroll(0,'absolute')
row = cur.fetchone()
while row is not None:
print row
row = cur.fetchone()
print 'cursor move to top:'
cur.scroll(0,'absolute')
many = cur.fetchmany(count)
print many
def deletedb():
sql = 'delete from test where `sort` = "%s"'
exsql = sql % ('python')
cur.execute(exsql)
conn.commit()
return 'delete success'
print insertdb()
print insertdb()
selectdb()
print deletedb()
四、关闭连接
总结
以上是编程之家为你收集整理的Python中操作MySQL入门实例全部内容,希望文章能够帮你解决Python中操作MySQL入门实例所遇到的程序开发问题。
如果您也喜欢它,动动您的小指点个赞吧