Deleting rows from database automatically

[svgmx5]

i'm fairly new to using mysql/sql I've used it before with php and what now, but never really on its own.

 

Which is why i'm curious to know if there is a way to automatically delete rows from my table.

 

Say for example...

 

i have a table that holds comments, and i want that table to delete all comments that are older than 30 days from the current date. Instead of having to do it manually or through out a php script, i was wondering if i could do it through the database?

 

 

[trq]

In 5.5 there is an event scheduler (see http://dev.mysql.com/doc/refman/5.5/en/events.html) otherwise, you'll need to use your OS's scheduler to schedule a job for execution.

[svgmx5]

thanks,

 

i wasn't sure if that was possible, but i guess i'll just use that or use a php script to delete them

[Mchl]

The scheduler is available since 5.1  (and works great)

[fenway]

The scheduler is available since 5.1  (and works great)

Really? No strange bugs?

[Mchl]

Didn't notice any.