How to create triggers in Data Grip?

mysql triggers datagrip
Shankha057 picture Shankha057 · Apr 28, 2017 · Viewed 7.4k times · Source

I want to create triggers in my table.I am using Data Grip as an interface to connect to my database.I googled around and the documentation said that it had something like a "Generate" drop down list which has something like function and procedures templates available for creation.But I get no such drop down list and even when I go to the new option after right clicking a table,I don't get an option for functions or procedures. I am using DataGrip 2017.1.2 and a MySQL data source.

Answer

kassak picture kassak · May 24, 2017

As an alternative to @Andrew 's answer (since 2016.3 or .2), you can:

  • Open database console
  • Press Alt+Ins (Cmd+N on Mac)
  • "Generate" menu will pop up
  • Select "Trigger"
  • A "live template" will start
  • Type trigger name...Enter
  • Type table name...Enter
  • ...
  • Execute resulting script with Ctrl+Enter

Related questions

MySQL Trigger after update only if row has changed

Is there any possibility to use an "after update" trigger only in the case the data has been REALLY changed. I know of "NEW and OLD". But when using them I'm only able to compare columns. For example "NEW.count &…

Read More
MySQL Trigger - Storing a SELECT in a variable

I have a trigger in which I want to have a variable that holds an INT I get from a SELECT, so I can use it in two IF statements instead of calling the SELECT twice. How do you declare/…

Read More
How do you list all triggers in a MySQL database?

What is the command to list all triggers in a MySQL database?

Read More