How to make event or routine
I'm just trying heidiSQL and want to make a stored procedure, event etc,
But when I right clik on table name and go to menu "create new", it only have option table and table copy enabled to be choose, the other like trigger, event, etc is disabled.. how can I use it?
For events, you also have to activate the server scheduler. That is, set the global variable "event_scheduler" to "ON". Or better: do that in the mysql.ini on the server to make that setting persistent overtaken when the server restarts.
Please login to leave a reply, or register at first.