Automatically insert in a SQL table after regular intervals

Question

I need to take all rows from table1 and copy it to table2 at midnight each day. Just like a backup.

What could a possible way out?

I am using MySQL and Xampp server with PHP

Daniel Heinrich · Accepted Answer · 2017-09-16 07:11:37Z

1

You could use a cronjob if you're using linux or the scheduler if you're using windows.

answered Sep 16, 2017 at 7:11

Daniel Heinrich

8005 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ashutosh Srivastava · Accepted Answer · 2017-09-16 07:47:01Z

1

Expand the SQL Server Agent node and right click the Jobs node in SQL
Server Agent and select 'New Job' In the 'New Job' window enter the name of the job and a description on the 'General' tab.
Select 'Steps' on the left hand side of the window and click 'New' at the bottom.
In the 'Steps' window enter a step name and select the database you want the query to run against. Paste in the T-SQL command you want to run into the Command window and click 'OK'.
Click on the 'Schedule' menu on the left of the New Job window and enter the schedule information (e.g. daily and a time). Click 'OK' - and that should be it.

Let me know if it helps

answered Sep 16, 2017 at 7:47

112 bronze badges