0

Hi i have a problem i cannot find a way to solve my problem:

enter image description here

I want to delete for each accountNumber older Data then X Days how is this possible ?

Best regards

Gordon Linoff
  • 1,242,037
  • 58
  • 646
  • 786
CranckRa1n
  • 1
  • Does this answer your question? [Delete all rows with timestamp older than x days](https://stackoverflow.com/questions/21206361/delete-all-rows-with-timestamp-older-than-x-days) – Fel May 01 '20 at 14:05

1 Answers1

0

Does this do what you want?

delete t from t
    where date < curdate() - interval X day;

If not, please provide more information in your question.

Gordon Linoff
  • 1,242,037
  • 58
  • 646
  • 786
  • no, i need to delete for every accountnumber the old data , maybe it works instad of using the date a limit of 70 – CranckRa1n May 01 '20 at 11:51