一、安装mysql-python
复制代码 代码如下:
# yum install -y mysql-python
二、打开数据库连接
复制代码 代码如下:
#!/usr/bin/python
import 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')
    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()
注意顺序。