distal-attribute
distal-attribute
distal-attribute
distal-attribute

How to make event or routine

AndyLPJr posted 3 years ago in HeidiSQL portable
Hello all, please help me..

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?

Thanks.
Noobulater posted 3 years ago
Another newbie with this tool, I found how to create the events, But how Do I get my code to run in the interval I want it to. As of Now it just sits in my DB and doesn't run.
ansgar posted 3 years ago
If something is greyed out in that "New" submenu, your server version does not support that.

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.
AndyLPJr posted 3 years ago
Hmm... Yeah, my server version is below 5, so there is no other way to make procedure on mysql below 5?
ansgar posted 3 years ago
No, apart from upgrading your server there is no way to get procedures.

AndyLPJr posted 3 years ago
I got it.. :(

thx for the help anse.. happy

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