Breaking News: Grepper is joining You.com. Read the official announcement!

mysql drop all triggers database

hirohito answered on December 28, 2022 Popularity 6/10 Helpfulness 4/10

answer mysql drop all triggers database

mysql drop all triggers database

Comment

-- set `group_concat_max_len`
SET @@session.group_concat_max_len = @@global.max_allowed_packet;

-- select all the triggers and build the `DROP TRIGGER` SQL
-- replace <your_schema> with your schema name (e.g. your database name)
SELECT GROUP_CONCAT(sql_string SEPARATOR '\n')
FROM (
    SELECT CONCAT('DROP TRIGGER IF EXISTS `', TRIGGER_NAME, '`;') AS sql_string,'1'
    FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA = '<your_schema>'
    ) AS sql_strings
GROUP BY '1';

-- example result:
-- DROP TRIGGER IF EXISTS `trigger1`;
-- DROP TRIGGER IF EXISTS `trigger2`;
-- (...)

Popularity 6/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: database drop mysql phpmyadmin sql triggers

Link to this answer
Share Copy Link