Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

Edit an existing trigger?

sfatula's profile image sfatula posted 2 years ago in General

I see how one can create a new trigger using the GUI, but not modify an existing one or delete one. Yes, I am aware one can do so via mysql statements, but, that's the purpose of Heidisql too, to avoid having to know all the syntax.

I see a post from HeidiSQL long ago, which I cannot post a link to as I don't have authorization yet, but it's on the heidisql site and has screenshots.php?which=trigger_editor in it. It says create and modify, so, I am thinking modify must be a function, I just can't find it! Can anyone direct me to where in the GUI to modify an existing trigger, or even see it?

ansgar's profile image ansgar posted 2 years ago

You should see triggers on the "Database" tab, just where the tables, views and procedures are. Doubleclicking a trigger should show you the trigger editor.

sfatula's profile image sfatula posted 2 years ago

It appears it is more a function of having full table status turned off, which I did.



Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
scottlapointe's profile image scottlapointe posted 4 months ago

Just found this -- is there a way to have any triggers related to a table show up in the table view? Maybe a triggers tab? then you could double click to open....

balexandre's profile image balexandre posted 3 months ago

@scottlapointe you already have that... as long as you have triggers on that database

to check the current trigger in your instance (mySQL):

SELECT * FROM information_schema.triggers

and if you have triggers in a database, you will see them as:

Please login to leave a reply, or register at first.