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