首页 > 代码库 > python学习笔记十一:操作mysql
python学习笔记十一:操作mysql
一、安装MySQL-python
# yum install -y MySQL-python
二、打开数据库连接
#!/usr/bin/pythonimport MySQLdbconn = MySQLdb.connect(user=‘root‘,passwd=‘admin‘,host=‘127.0.0.1‘)conn.select_db(‘test‘)cur = conn.cursor()
三、操作数据库
def insertdb(): sql = ‘insert into test(name,`sort`) values ("%s","%s")‘ exsql = sql % (‘hello‘,‘python‘) return cur.execute(exsql)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 manydef deletedb(): sql = ‘delete from test where `sort` = "%s"‘ exsql = sql % (‘python‘) return cur.execute(exsql)print insertdb()print insertdb()selectdb()print deletedb()
四、关闭连接
cur.close()conn.close()
注意顺序。
python学习笔记十一:操作mysql
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。