Python operation MySQL Simple implementation method _python

The example of this article describes the python operation of MySQL simple implementation method. Share to everyone for your reference. The specific analysis is as follows:

First, Installation:

installing MySQL

Install MySQL Needless to say, download down installation is, there is no particular need to pay attention to the place.

One download address: Click on the Open link

Second, the example:

Copy Code code as follows:

# Coding=utf-8
Import MySQLdb

#查询数量
def Count (cur):
Count=cur.execute (' select * from Student ')
print ' There has%s rows record '% count

#插入
def Insert (cur):
sql = "INSERT into Student (id,name,age,sex) VALUES (%s,%s,%s,%s)"
param = (2, ' xiaoming ', ' Boy ')
Cur.execute (Sql,param)

#查询
def Select (cur):
n = Cur.execute ("SELECT * from Student")
Print "------"
For row in Cur.fetchall ():
For R in row:
Print R
Print "------"
#更新
def Update (cur):
sql = "Update Student set Name =%s where ID = 2"
param = ("Xiaoxue")
Count = Cur.execute (Sql,param)

#删除
def Delete (cur):
sql = "Delete from Student where Name =%s"
param = ("Xiaoxue")
n = Cur.execute (Sql,param)

Try
Conn=mysqldb.connect (host= ' localhost ', user= ' root ', passwd= ' 123456 ', db= ' python ', port=3306)
Cur=conn.cursor ()
#数量
Count (cur)
#查询
Select (cur)
#插入
Insert (cur)
Print "After Insert"
#查询
Select (cur)
#更新
Update (cur)
print "After Update"
#查询
Select (cur)
#删除
Delete (cur)
print "After delete"
#查询
Select (cur)

Cur.close ()
Conn.close ()

Except Mysqldb.error,e:
Print "Mysql Error%d:%s"% (E.args[0], e.args[1])

I hope this article will help you with your Python programming.