How to make event or routine
| User, date | Message |
|---|---|
|
Written by AndyLPJr
2 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
2 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
2 years ago 3958 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
2 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
2 years ago 3958 posts since Fri, 07 Apr 06 |
No, apart from upgrading your server there is no way to get procedures. |
|
Written by AndyLPJr
2 years ago 3 posts since Mon, 21 Nov 11 |
I got it.. :( thx for the help anse.. 
|
|
Please login to leave a reply, or register at first. |