How can a data be moved from one table to another table automatically,maybe houry or daily? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

How can a data be moved from one table to another table automatically,maybe houry or daily?

https://code.sololearn.com/WBzJy47SR1I2/?ref=app

3rd Dec 2023, 7:46 AM
alphonce milambo
alphonce milambo - avatar
5 Answers
+ 3
You can read data from table 1 and write to table 2. After that delete the data in table 1.
3rd Dec 2023, 10:05 AM
JaScript
JaScript - avatar
+ 3
Here something about cron job. Good luck. https://en.m.wikipedia.org/wiki/Cron
3rd Dec 2023, 1:51 PM
JaScript
JaScript - avatar
+ 2
You could start an app that this do with a periodicaly CRON job of the server or you cold use similar way to this: https://sololearn.com/compiler-playground/wog9vFBtJwcd/?ref=app
3rd Dec 2023, 1:05 PM
JaScript
JaScript - avatar
+ 1
I created a website,in which I want the data to be moved from one table to another everyday,automatically
3rd Dec 2023, 11:37 AM
alphonce milambo
alphonce milambo - avatar
+ 1
Atleast you understood me,let me check it out
3rd Dec 2023, 1:19 PM
alphonce milambo
alphonce milambo - avatar