On 12/3/03 7:27 PM [EMAIL PROTECTED] wrote:
Hi,
yah that's what I'm looking for, creating a "cronjob" whereby this "cron" will
automatically delete the record once 30 days is up...maybe using something
like that:
"DELETE FROM tablename
WHERE (DATA_SUB(NOW()), INTERVAL 30 DAY) > name_of_date_
Hi all:
Having some doubts with sql select queries here :
Right now, I have a "student" and a "withdraw" tables.
For example, when student "John" has withdrawn, his name will be inserted
into "withdraw" table but John's record will be kept in "student" table for a
period of 30 days befor
Hi all:
Having some doubts with sql select queries here :
Right now, I have a "student" and a "withdraw" tables.
For example, when student "John" has withdrawn, his name will be inserted
into "withdraw" table but John's record will be kept in "student" table for a
period of 30 days before
