Python中操作MySQL入门实例

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

本文Python中操作MySQL入门实例到此结束。填充自己等待机会，表面上是忍，骨子里是不妥协。因为就算我忍的时候，我心里也清楚我是为什么忍，是为了更大的一个目标，能走的更远。小编再次感谢大家对我们的支持！