Compile Maria database very 30 days interval

Hi , Good day,

I am getting raw data into my database (table) every second and filling up my database - no issue on that part. I want to compile my data every 30 days interval automatically example date from 15/jan ~ 14/feb and so on. Is that possible in Maria db
Rama TitoProgrammerAsked:
Who is Participating?
 
pcelbaConnect With a Mentor Commented:
Yes, this is possible. You may use ADDDATE or DATE_ADD function to calculate the date + 30 days.

More info: https://mariadb.com/kb/en/mariadb/date-and-time-functions/

To execute the compilation every 30 days just CREATE EVENT: https://mariadb.com/kb/en/mariadb/events/

More info: https://mariadb.com/kb/en/mariadb/create-event/

Your compilation will be more complex than one simple statement so I would recommend to create and call Stored Procedure.

More info: https://mariadb.com/kb/en/mariadb/stored-procedures/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.