Python中操作MySQL入门实例
一、安装MySQL-python
复制代码 代码如下:
# yum install -y MySQL-python
二、打开数据库连接
复制代码 代码如下:
#!/usr/bin/python
import MySQLdb
conn = 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\’)
cur.execute(exsql)
conn.commit()
return \’insert success\’
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()
四、关闭连接
复制代码 代码如下:
cur.close()
conn.close()
注意顺序。
上一篇：Python文件和目录操作详解