On Apr 7, 2018, at 09:41, MarcoAurelio <strigiwm@gmail.com> wrote:

Hi,

I'd like to issue a command to a database our team manages to clean all data older than 30 days.

Browsing around I've found that:

DELETE FROM $table WHERE $timestamp < NOW() - INTERVAL 30 DAY

could work, but I'd like to check with you first just in case you have a better command or ideas.

Thanks in advance for your help.

Best regards, M.

_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud