How to make event or routine

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.

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.

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.

Hmm... Yeah, my server version is below 5, so there is no other way to make procedure on mysql below 5?

No, apart from upgrading your server there is no way to get procedures.

I got it.. :(

thx for the help anse..