Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

How to make event or routine

AndyLPJr's profile image AndyLPJr posted 9 years ago in HeidiSQL portable Permalink
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's profile image Noobulater posted 9 years ago Permalink
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's profile image ansgar posted 9 years ago Permalink
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's profile image AndyLPJr posted 9 years ago Permalink
Hmm... Yeah, my server version is below 5, so there is no other way to make procedure on mysql below 5?
ansgar's profile image ansgar posted 9 years ago Permalink
No, apart from upgrading your server there is no way to get procedures.
AndyLPJr's profile image AndyLPJr posted 9 years ago Permalink
I got it.. :(

thx for the help anse.. happy

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.