dauruk0512 Posted February 15, 2016 Share Posted February 15, 2016 http://prntscr.com/a3dz84 please check why it doesn't working ? i have been tested change date in local computer but nothing happen, thanks UPDATE `cu_employee` SET `cu_employee_sisa_cuti` = '12' WHERE 1 Link to comment Share on other sites More sharing options...
davej Posted February 15, 2016 Share Posted February 15, 2016 See... http://www.w3schools.com/sql/sql_update.asp Link to comment Share on other sites More sharing options...
dauruk0512 Posted February 17, 2016 Author Share Posted February 17, 2016 hi moderator thanks for comment, no i know update query i mean here my event doesn't working ? sorry late respond cause i leave programming 2 days, thanks Link to comment Share on other sites More sharing options...
davej Posted February 17, 2016 Share Posted February 17, 2016 Have you read the documentation? http://dev.mysql.com/doc/refman/5.5/en/events-overview.html Link to comment Share on other sites More sharing options...
dauruk0512 Posted February 18, 2016 Author Share Posted February 18, 2016 i didn't read that before posting but i follow all instruction in stackoverflow and google and it same with documentation mention on it (i'm on reading documentation now), well i almost give up on this issue but will you help me to debug where do i wrong, please correct ya i set status enabled status event by adding event_scheduler=ON // in xammp/mysql/bin/my.ini then i restart xampp but nothing happen, i don't know how to debug each month, i change date in local computer but nothing respon if only 10 second it give me working fine, thanks a lot Link to comment Share on other sites More sharing options...
davej Posted February 18, 2016 Share Posted February 18, 2016 Yes, but have you tried using a SQL command that is always SUCCESSFUL in the MySQL console? Link to comment Share on other sites More sharing options...
dauruk0512 Posted February 18, 2016 Author Share Posted February 18, 2016 do you mean copy and paste this script to sql box UPDATE `cu_employee` SET `cu_employee_sisa_cuti`=cu_employee_sisa_cuti+cu_employee_jatah_cuti WHERE 1 yes it give me success but nothing happen in my event, thanks for reading this well sorry if this is cross question i post in here also but not give results Link to comment Share on other sites More sharing options...
davej Posted February 18, 2016 Share Posted February 18, 2016 I've never used the MySQL event scheduler but all the documentation is online... http://dev.mysql.com/doc/refman/5.5/en/events-configuration.html Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now