Most Popular
Recently Added
Recently Updated

Drop Triggers Batch File for MySQL

Replace {User}, {Password} and {Database}

mysql -u{User} -p{Password} -e "select concat(concat('drop trigger ', trigger_name),';') as '' from information_schema.triggers where upper(event_object_schema) = upper('{Database}') and (trigger_name like 'ON_%%' or trigger_name like 'SYM_%%')" {Database} > drop_triggers.tmp 
mysql -u{User} -p{Password} {Database} 

Properties ID: 000020   Views: 1575   Updated: 8 years ago
Filed under: