Any mySQL experts around?
 

Anyone know how to do this in mySQL?

I have a table with a datetime column and need to delete all entries that are older than 15 days.

Hugs,
Danielle

Delete from <TABLENAME>
Where 1=1

first try select * from table where datecolumn<now()-15 ...
if it works, replace to delete

to view the data:
select * from tablename where datetime < DATE_ADD(now(), interval -15 day) order by datetime;

and if it looks right, to delete:
delete from tablename where datetime < DATE_ADD(now(), interval -15 day);

Thanks. That looks like what I was looking for.

Hugs,
Danielle

Oh should that be DATE_SUB insteat of DATE_ADD???

Hugs,
Danielle

no prob :)

it will just add the -15...so it will work fine...either way

Thanks. It makes total sinse to me now.

Hugs,
Danielle