How to schedule a stored procedure in MySQL

by

You can use mysql scheduler to run it each 5 seconds. You can find samples at http://dev.mysql.com/doc/refman/5.1/en/create-event.html

Never used it but I hope this would work:

CREATE EVENT myevent
    ON SCHEDULE EVERY 5 SECOND
    DO
      CALL delete_rows_links();

More Related Contents:

  1. MySQL stored procedures use them or not to use them
  2. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  3. How do you debug MySQL stored procedures?
  4. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. Is there a MySQL option/feature to track history of changes to records?
  7. Can I create view with parameter in MySQL?
  8. Using an Alias in SQL Calculations
  9. MySQL stored procedure vs function, which would I use when?
  10. mysql dynamic query in stored procedure
  11. Check for x consecutive days – given timestamps in database
  12. MySQL Insert Into from one Database in another
  13. How do I get the ID of multiple inserted rows in MySQL?
  14. Dynamic table names in stored procedure function
  15. passing LIMIT as parameters to MySQL sproc
  16. How do I show the schema of a table in a MySQL database?
  17. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  18. MySQL concatenating all columns
  19. Remove special characters from a database field
  20. MySQL Stored Procedure Error Handling
  21. Proper database model for a user feedback system (an interesting case)
  22. How big can a MySQL database get before performance starts to degrade
  23. How to get multiple records against one record based on relation?
  24. Easiest way to copy a table from one database to another?
  25. What is the best way to store media files on a database?
  26. How to use a user variables in MySQL LIKE clause?
  27. remove all numeric characters from column mysql
  28. Selecting distinct 2 columns combination in mysql
  29. Inventory management with stock options
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment