# coding=gbk
import MySQLdbimport os
try:
conn=MySQLdb.connect(host='localhost',user='root',passwd='****',db='user',port=3306)
#打开连接
cur=conn.cursor()
# 查询birthdayinfo表下的所有触发器
cur.execute("select TRIGGER_NAME from information_schema.`TRIGGERS` WHERE EVENT_OBJECT_TABLE='birthdayinfo'")infos=cur.fetchall()
for item in infos:
s = str(item)
#把查出来的形如 [('trg_birthdayinfo_ai',) 的触发器名称改为 trg_birthdayinfo_ai
s=s[2:-3]
sql = 'DROP TRIGGER if EXISTS '+s
#print sql
cur.execute(sql)
print '删除['+str(item)+']触发器成功'
cur.close()
conn.close()
print os.system('@pause')
except MySQLdb.Error,e:
print 'Mysql Error %d:%s' % (e.args[0],e.args[1])