Hi all,

I have mysql table that has a field named 'crea_dt' (it records the creation date of 
data)...

I want to delete records that have passed for more than a day

description like this : if now()-crea_dt > 0 then delete

But I just can't find the suitable mysql command for this function.

Anyone can help me, thanks a lot.

By regard;


Sukanto

Reply via email to