Mysql event error using php

by

Create the Event:

drop event if exists `myevent21222`;
DELIMITER |
CREATE EVENT myevent21222
  ON SCHEDULE EVERY 5 MINUTE STARTS '2016-01-01 00:00:00'
  ON COMPLETION PRESERVE
DO
  BEGIN
    UPDATE `team` SET `reg` = '0' WHERE `id` = '1';
  END |
  # MySQL lieferte ein leeres Resultat zurück (d.h. null Datensätze).
DELIMITER ;

Turn on the event handler:

SET GLOBAL event_scheduler = ON;  -- turn her on and confirm below

Confirm it is on:

show variables where variable_name="event_scheduler";

Check out event info:

show events from so_gibberish2; -- note so_gibberish2 is my database name

— obviously use your database name above

enter image description here

Look at the manual page for what ON COMPLETION PRESERVE means as well as other things.

Disable or enable it:

ALTER EVENT myevent21222 disable;
ALTER EVENT myevent21222 enable;

More Related Contents:

  1. Can I store query result of one field into different variables? if not then what should I do for that?
  2. The requested URL was not found on this server.
  3. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  4. How to write a stored procedure using phpmyadmin and how to use it through php?
  5. Import file size limit in PHPMyAdmin
  6. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  7. Access denied for user ‘root’@’localhost’ with PHPMyAdmin
  8. Store procedures in phpMyAdmin
  9. How to solve time out in phpmyadmin?
  10. WAMP/MySQL errors not in correct language
  11. phpmyadmin automatic logout time
  12. #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
  13. Unknown database error in PHP but it exists in PHPMyAdmin
  14. Extension mysqli is missing, phpmyadmin doesn’t work
  15. How to SELECT DEFAULT value of a field
  16. How to log in to phpMyAdmin with WAMP, what is the username and password?
  17. Auto Increment skipping numbers?
  18. How to write a stored procedure in phpMyAdmin?
  19. Installing PDO driver on MySQL Linux server
  20. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’
  21. Comma separated numeric values – PHP CodeIgniter
  22. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  23. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  24. How to loop through a mysql result set
  25. mysql_num_rows() expects parameter 1 to be resource, boolean given in [duplicate]
  26. Easy way to export a SQL table without access to the server or phpMyADMIN
  27. How can I do a migration in laravel 5.5?
  28. How to get last inserted id from table MySQL [duplicate]
  29. How can I list data in sections by an ID, with a while loop in PHP? [closed]
  30. find in set in laravel ? example

Leave a Comment