little mysql help pleas

[TheSky]

is there way to delete database rows what are like older then 30 days i have colum named today and i want like delete older then 30 days rows value is like 2011.06.12

thankyou for your time

[The Little Guy]

step 1 (optional):

backup your table

 

step 2:

Convert your date to a valid mysql date:

update my_table replace(my_date_column, '.', '-');

 

step 3:

Convert your date column to a date:

alter table my_table change  my_date_column my_date_column date not null

 

step 4:

add the code to delete dates older than 30 days:

delete from my_table where my_date_column > date_sub(now(), interval 30 day);

[TheSky]

SQL query:

UPDATE u_statistics replace( today, '.', '-' )

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'replace(today, '.', '-')' at line 1 

am i doing somthing wrong ?

[The Little Guy]

Oops, try this:

 

UPDATE u_statistics set today = replace( today, '.', '-' )

[The Little Guy]

Don't forget when you insert into this table, you need to use this format:

YYYY-MM-DD

[TheSky]

delete from my_table where my_date_column > date_sub(now(), interval 30 day);

:-\ it deleted all records not older then 30 days

[The Little Guy]

okay,  then just reverse: >

to: <

 

btw. I hope you backed up your table.

[TheSky]

step 1 (optional):

backup your table

ok i will try

[TheSky]

hmm it deletes now automaticaly ?

i think it worked