How to copy records from one table to another table, daily in mysql phpmyadmin

Question

I have a table in my database named master_table. I want to copy the records from this table to another table named daily_table, everyday at 8 am. The records copied everyday should not overwrite the existing records in the daily table. I'm using phpMyAdmin mysql. Is there any way to do this?

Yes, write a php script that does that and call that every day at 8am automatically using cron or something like Windows scheduler. — jeroen, Mar 04 '15 at 07:30
Check about http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html — Abhik Chakraborty, Mar 04 '15 at 07:31

score 1 · Answer 1 · edited May 23 '17 at 12:28

1

If both tables are truly the same schema:

INSERT INTO newTable SELECT * FROM oldTable

Reference : here

edited May 23 '17 at 12:28

Community

1
1

answered Mar 04 '15 at 07:34

Ganesh Salunkhe

596
1
4
18

How to copy records from one table to another table, daily in mysql phpmyadmin

1 Answers1