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()

注意顺序。