how to delete rows out of date of a given period

[scorpioy]

I installed MySQL5.0.0 on my WinXP. Could someone tell me how do I do in order to automatically delete some rows in some table if certain rows' date is older than a given period of time, say, a month. (when I insert a row to the table, I use CURDATE() to get date).

Is this what I should put into a batch file?

mysql -u root db_name < delete.sql

where db_name is the database name and delete.sql is the file that I put sql statement in

[devinemke]

DELETE FROM table WHERE date < '2005-03-17'

where 2005-03-17 is the "given" date

[scorpioy]

DELETE FROM table WHERE date < '2005-03-17'

this would be the hard coding. If I want to delete rows that are one month old, I have to change query everyday. So is there a better way to implement?

THanks.

[devinemke]

DELETE FROM table WHERE UNIX_TIMESTAMP(date) < (UNIX_TIMESTAMP() - 2592000)

[scorpioy]

Thank you. It works now.