Any mySQL experts around?

[Danielle]

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

[WarChild]

Delete from <TABLENAME>
Where 1=1

[margarita]

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

[UnifiedStats_John]

Originally Posted by Danielle

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

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);

[Danielle]

Originally Posted by UnifiedStats_John

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

[Danielle]

Oh should that be DATE_SUB insteat of DATE_ADD???

Hugs,
Danielle

[UnifiedStats_John]

Originally Posted by Danielle

Thanks. That looks like what I was looking for.

Hugs,
Danielle

no prob

[UnifiedStats_John]

Originally Posted by Danielle

Oh should that be DATE_SUB insteat of DATE_ADD???

Hugs,
Danielle

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

[Danielle]

Originally Posted by UnifiedStats_John

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

Thanks. It makes total sinse to me now.

Hugs,
Danielle