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

How to make event or routine

User, date Message
Written by AndyLPJr
3 years ago
Category: HeidiSQL portable
3 posts since Mon, 21 Nov 11
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.
Written by Noobulater
3 years ago
1 posts since Mon, 21 Nov 11
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.
Written by ansgar
3 years ago
4936 posts since Fri, 07 Apr 06
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.
Written by AndyLPJr
3 years ago
3 posts since Mon, 21 Nov 11
Hmm... Yeah, my server version is below 5, so there is no other way to make procedure on mysql below 5?
Written by ansgar
3 years ago
4936 posts since Fri, 07 Apr 06
No, apart from upgrading your server there is no way to get procedures.
Written by AndyLPJr
3 years ago
3 posts since Mon, 21 Nov 11
I got it.. :(

thx for the help anse.. happy
 

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