Home >Backend Development >Python Tutorial >Python中操作MySQL入门实例

Python中操作MySQL入门实例

WBOY
WBOYOriginal
2016-06-10 15:17:581205browse

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

注意顺序。
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn