Python中操作MySQL入门实例

发布时间：2020-12-16 19:40:23 所属栏目：Python 来源：网络整理

导读：一、安装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 = c

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

注意顺序。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!