List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:July 15 1999 4:54am
Subject:Re: about delete automatically
View as plain text  
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
about delete automaticallybben15 Jul
  • Re: about delete automaticallyPaul DuBois15 Jul
  • Re: about delete automaticallyDan Nelson15 Jul