# coding=gbk

import MySQLdb

import 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])