469,645 Members | 1,127 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

How to Automatic Delete Row by Period Time (phpMyAdmin)?

Hello everyone. I need your help to finishing my Diploma Final Project. I have database MySQL in phpMyAdmin. Database name is "logger" and table name is "logger". The table have 2 column, there are: 1. Date & Time (timestamp type) and 2. Information (text type).
The date in database is receive for arduino every second. So, i want to delete the date after 14 days created in database. How do the solution for my final project problem?
Jun 8 '19 #1
3 2322
1,044 Expert 1GB
Is it a 1-time-action? Or should all actions be automatically be deleted when they are older than 14 days?

When it's a one-time action, you should be able to craft a 'DELETE FROM logger WHERE ...' statement in SQL. If you are not able to create that, than you fail exams for your Diploma Final Project.

If this needs to be done 'automatically', I do mean that everything older than 14 days is deleted, so when you come back tomorrow, or the day after tomorrow, you still do not see records that are older than 14 days. you wil need to read the manual for MySQL for it where it explains the Event Scheduler
Jun 8 '19 #2
It's all action automatically be deleted when the date older than 14 days.
Ok thanks you, Luuk for the solution
Jun 8 '19 #3
5,400 Expert Mod 4TB
(...) How do the solution for my final project problem? (...)
This is a Homework problem.
How is it fair to yourself, or your fellow classmates, that Luuk provided the solution?

FAQ: Posting Homework or Coursework Questions and Answers
Posting Homework or Coursework Questions and Answers
Any and all Homework/Coursework questions will be deleted. If you see a question that is a homework or coursework assignment then please remember DO NOT attempt to post a reply. Replies to this thread will be deleted along with the original post. Please 'report' the thread.
\\Thread is closed//
Jun 9 '19 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by JK.Jarmen | last post: by
5 posts views Thread by Nick | last post: by
9 posts views Thread by rohits123 | last post: by
1 post views Thread by mallz | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.