首页 > 代码库 > python MySQLdb 对mysql基本操作方法
python MySQLdb 对mysql基本操作方法
1 #!/usr/bin/env python 2 # -*- coding:utf-8 -*- 3 import MySQLdb 4 5 conn = MySQLdb.connect(host=‘192.168.1.101‘,user=‘root‘,passwd=‘123‘,db=‘host‘) 6 cur = conn.cursor(cursorclass=MySQLdb.cursors.DictCursor) 7 reCout = cur.execute(‘select ip,name from host,user where user.name = "alex" and user.id=host.id‘) 8 nRet = cur.fetchall() 9 conn.commit() 10 cur.close() 11 conn.close() 12 print reCout 13 print nRet 14 for i in nRet: 15 print i[‘name‘],i[‘ip‘] 16 17 """ 18 #修改 19 conn = MySQLdb.connect(host=‘192.168.1.101‘,user=‘root‘,passwd=‘123‘,db=‘host‘) 20 cur = conn.cursor() 21 reCout = cur.execute(‘update host set id=%s‘,(1,)) 22 conn.commit() 23 cur.close() 24 conn.close() 25 print reCout 26 """ 27 """ 28 #删除 29 conn = MySQLdb.connect(host=‘192.168.1.101‘,user=‘root‘,passwd=‘123‘,db=‘host‘) 30 cur = conn.cursor() 31 reCout = cur.execute(‘delete from host‘) 32 conn.commit() 33 cur.close() 34 conn.close() 35 print reCout 36 """ 37 """ 38 l = [ 39 (‘192.168.1.107‘,‘2‘), 40 (‘192.168.1.108‘,‘2‘), 41 (‘192.168.1.109‘,‘2‘), 42 (‘192.168.1.177‘,‘2‘), 43 ] 44 #插入多条数据 45 conn = MySQLdb.connect(host=‘192.168.1.101‘,user=‘root‘,passwd=‘123‘,db=‘host‘) 46 cur = conn.cursor() 47 reCout = cur.executemany(‘insert into host(ip,id) values(%s,%s)‘,l) 48 49 conn.commit() 50 cur.close() 51 conn.close() 52 print reCout 53 """ 54 """ 55 #插入单条数据 56 conn = MySQLdb.connect(host=‘192.168.1.101‘,user=‘root‘,passwd=‘123‘,db=‘host‘) 57 cur = conn.cursor() 58 reCout = cur.execute(‘insert into host(ip,id) values(%s,%s)‘,(‘192.168.1.1‘,‘1‘)) 59 60 conn.commit() 61 cur.close() 62 conn.close() 63 print reCout 64 """
python MySQLdb 对mysql基本操作方法
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。