【安装】安装MySQL
安装MySQL不用多说了，下载下来安装就是，没有特别需要注意的地方。
一个下载地址：点击打开链接
【样例】
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
# coding=utf-8
importMySQLdb
#查询数量
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',24,'boy')
cur.execute(sql,param)
#查询
def Select(cur):
n = cur.execute("select * from Student")
print"------"
forrow in cur.fetchall():
forr 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"插入之后"
#查询
Select(cur)
#更新
Update(cur)
print"更新之后"
#查询
Select(cur)
#删除
Delete(cur)
print"删除之后"
#查询
Select(cur)
cur.close()
conn.close()
except MySQLdb.Error,e:
print"Mysql Error %d: %s"% (e.args[0], e.args[1])