Re: about delete automatically

[Dan Nelson]

In the last episode (Jul 15), bben said:
> hello
> 
> I have a table,and it has a column "data". how can I delete all of
> record that column "data" is less than 100 automatically? my means is:
> let mysql check the table and delete the record automatically
> everyday.

Sounds like a job for cron.

#minute	hour mday month wday command
0 3 * * * mysql -e "delete from my_table where data < 100" my_dbase

	-Dan Nelson
	dnelson@stripped