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