分类: Python/Ruby
2015-09-09 17:33:04
# -*- coding: utf-8 -*- import pymysql conn = pymysql.connect(host='192.168.1.200',user='root', passwd='fangjipu', db='falcon') # conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd=None, db='mysql') cur = conn.cursor() #cur.execute("SELECT * FROM stat") #for r in cur: # print(r) #删除语句,可批量删除 def exeDelete(cur,IDs): for eachID in IDs.split(' '): sta=cur.execute('delete from stat where ID =%d'% int(eachID)); return (sta); def exeQuery(cur,sql):#查询语句 cur.execute(sql); return (cur); #带条件的查询 ID=input("请输入ID号:") a=exeQuery(cur,'select * from stat where ID =%d'% int(ID)) for b in a: print(b) tempID=input('请输入要删除的编号 编号之间用空格分开:'); sta=exeDelete(cur, tempID); if(sta==1): print('删除成功'); else: print('删除失败'); cur.close() conn.close()#效果请输入ID号:2 (2, 'example.com', 524, 456, 980, '0.00,0.02,0.07', 1441791934) 请输入要删除的编号 编号之间用空格分开:20 删除成功