Hi, long time ago you gave me a CRON command to delete data from "asq_quiz_sessions" database (leaving data only for the last two days). And it works, as expected.

However, there is also an "asq_quiz_session_activities" database, and it has data since 2020 till current time. Just wanted to ask you, it it's safe to delete data from asq_quiz_session_activities as well? If yes, then can you give a CRON command?

Just in case, here is a code, that you gave me: "DELETE FROM wp_asq_quiz_sessions WHERE created <DATE_ADD(CURDATE(), INTERVAL -2 DAY)"

Is it okay, if I use the same code for "asq_quiz_session_activities" ?

Hello

You can try the following query:



Regards,
ARI Soft

I've just tried to run this command in my CRON panel, but it didn't delete any tables in "asq_quiz_session_activities" database.

Maybe something has to be changed in your command?

Atm "wp_asq_quiz_session_activities" database has 177.177 tables in almost 5 years. And it's 10+MB.

So I would like to safely clear unnecessary data somehow. Please, help.

You can create another query for "activities" table:



Regards,
ARI Soft