How many times a event fired in mysql

Question

I created an event in MYSQL with schedule date. For example the event fire on current month first date.

Am using the below query to select the current month first date

select CAST(DATE_FORMAT(NOW(),'%Y-%m-01') as DATE)

My doubt is how many time the event fire on that date.

you can see by using prefix `EXPLAIN` on your query `"EXPLAIN SELECT...."` — xkeshav, Aug 28 '12 at 05:39
@diEcho My question is how many times the event fired in a day.. — Milton Fernando, Aug 28 '12 at 05:46
If your event starts every first day of every month, it will be fired once a month. Why do you want to count - how many times the event fired in a day? — Devart, Aug 28 '12 at 06:35

score 1 · Accepted Answer · edited May 23 '17 at 11:49

you can analyze your query using EXPLAIN

"EXPLAIN SELECT CAST(DATE_FORMAT(NOW(),'%Y-%m-01') as DATE)";

alternative:

if you want to find first day of current month then you can can create a custom function

DELIMITER ;;
CREATE FUNCTION FIRST_DAY(day DATE)
RETURNS DATE DETERMINISTIC
BEGIN
  RETURN ADDDATE(LAST_DAY(SUBDATE(day, INTERVAL 1 MONTH)), 1);
END;;
DELIMITER ;
That way:

Reference

and then call

SELECT FIRST_DAY(DATE(NOW()));

How many times a event fired in mysql

1 Answers1

alternative: