Python中操作MySQL入门实例

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

四、关闭连接