MySQL events are very useful, since it’s not very often using, it may hard to remember the proper syntax. You can learn the syntax again and again or instead you can use this simple mysql event code generator tool that generate proper mysql code for you. http://www.ersinkarakadioglu.com/MySQL-Create-Event-Wizard