473,320 Members | 2,035 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 3769
Luuk
1,047 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
zmbd
5,501 Expert Mod 4TB
mrukmana02
(...) 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Alistair | last post by:
IIS, Access 2000 I have a page that tabulates data from a DB, this data is items for sale, private ads. is there a way that at the same time it can automatically delete entries that are...
1
by: Ant | last post by:
I installed the software and activated the 60 day free trail period for Visual Studio .NET yesterday. After completing the registration process for the product, yesterday, I received a popup...
1
by: ABC | last post by:
Is there any best solution automatic delete file within the special time? My web application can generate many pdf files for users. Because there are many users, I need to control the total...
1
by: JK.Jarmen | last post by:
hi everbody... i am using vb.net 2005 and sql server 2005. my master-detail table tableADISYON tableAYRINTI ID ID ADISYONNO ...
5
by: Nick | last post by:
HI All: I have problem to delete row in grid view. It always needs to click twice delete button to delete row. but everytime it fires the deleting and deleted event. I have no idea why the...
9
by: rohits123 | last post by:
I have an overload delete operator as below ////////////////////////////////// void operator delete(void* mem,int head_type) { mmHead local_Head = CPRMemory::GetMemoryHead(head_type);...
1
by: kbaisch | last post by:
I have a column with smalldatetime data type. When I run a query, it shows date and time, I only want the date adn to delete the time. It looks like this: 1979-04-25 00:00:00 What is the script...
1
by: mallz | last post by:
hi, i need to display the current time as soon as a user logs in. im using this code: long t1,t2,t3; Date d=new Date(); t1=d.getHours(); t2=d.getMinutes();
36
kirubagari
by: kirubagari | last post by:
How about the deletion function.i just modify the insert function to delete function.is it correct.actualy i would like to delete if 04 FF 04 FF (got repeating value) i would like to delete one of...
3
oranoos3000
by: oranoos3000 | last post by:
hi i want to get time of server with ajax,php,javascript i use under scritp and with method onload i get time on server and show on the page so i want in a period time the same function is run...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.