一、安装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()

注意顺序。