Database Related

Question

how to delete data on the database at the end of each month?? Please help

Joseph Thomas · Answer

If you are using MySql...Run this query on your database.. SET GLOBAL event_scheduler = ON; This will add a new tab called events. Go to events  add new event and set following fields like this Event Type :Recurring Execute Every: 1 > Month Set the start and end date Defintion : Truncate table_name

Nilesh Patil · Answer

Hi Please refer this links it may helps you https://stackoverflow.com/questions/17058344/how-to-automatically-delete-a-record-from-the-database-in-rails

anoop prajapati · Answer

Thanks but in this link automatically delete using ruby not php

Ankit Sharma · Answer

Hi Anoop you can either schedule a SQL job to achieve this task or do it manually at the end of each month. to schedule SQL job refer this. https://stackoverflow.com/questions/3840359/daily-sql-task-to-delete-contents-from-a-table To do it manually please refer this http://zarez.net/?p=542 Please let me know if it works for you

Midhun T P · Answer

Hi You could make use of SQL Jobs for that. Please refer below threads - http://www.c-sharpcorner.com/article/job-scheduling-in-sql-server/ http://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/