第 9 天 python操作mysql資料庫

標籤：

1、插入操作：

 1 #!/uer/bin/env python 2 # -*- coding:utf-8 -*- 3  4 import MySQLdb 5  6 conn = MySQLdb.connect(host=‘192.168.1.100‘,user=‘root‘,passwd=‘123456‘,db=‘oldb‘) 7  8 cur = conn.cursor() 9 10 reCount = cur.execute(‘insert into students(Name,sex,age,tel) values(%s,%s,%s,%s)‘,(‘alex2‘,‘man‘,19,‘18923143‘))11 # reCount = cur.execute(‘select * from students;‘)12 13 conn.commit()14 cur.close()15 conn.close()16 print(reCount)

輸出資訊:

3

2、查詢操作

 1 #!/uer/bin/env python 2 # -*- coding:utf-8 -*- 3  4 import MySQLdb 5  6 conn = MySQLdb.connect(host=‘192.168.1.100‘,user=‘root‘,passwd=‘123456‘,db=‘oldb‘) 7  8 cur = conn.cursor() 9 10 # reCount = cur.execute(‘insert into students(Name,sex,age,tel) values(%s,%s,%s,%s)‘,(‘alex4‘,‘man‘,29,‘18923143‘))11 reCount = cur.execute(‘select * from students;‘)12 13 14 print(cur.fetchone())
----------------------------------15 print(cur.fetchall()) #取出所有資料

----------------------------------

16 print(cur.fetchmany(3)) #指定3 條資料

輸出資訊:

(1L, ‘alex‘, ‘man‘, 18, ‘151515151‘)

------------------------------------

((1L, ‘alex‘, ‘man‘, 18, ‘151515151‘)

(2L, ‘alex2‘, ‘man‘, 19, ‘18923143‘)

(3L, ‘alex2‘, ‘man‘, 19, ‘18923143‘))

-------------------------------------

()

3、批量插入資料

 1 #!/uer/bin/env python 2 # -*- coding:utf-8 -*- 3  4 import MySQLdb 5  6 conn = MySQLdb.connect(host=‘192.168.1.100‘,user=‘root‘,passwd=‘123456‘,db=‘oldb‘) 7  8 cur = conn.cursor() 9 10 li = [11     (‘tommite‘,‘man‘,29,‘189231432‘),12     (‘kendi‘,‘man‘,26,‘189231433‘),13     (‘lili‘,‘man‘,19,‘189231434‘),14 ]15 16 reCount = cur.executemany(‘insert into students(Name,sex,age,tel) values(%s,%s,%s,%s)‘,li)17 18 conn.commit()19 cur.close()20 conn.close()21 print(reCount)

輸出資訊:

3

 

第 9 天 python操作mysql資料庫