Lowyat.NET Forums

Welcome Guest ( Log In | Register )

LYN wins Intel-Lenovo-Tangs Blogathon challenge. Thank you everybody!
 
 RSS feedBump TopicReply to this topicStart new topicStart Poll

Outline · [ Standard ] · Linear+

> Automaticall delete records from MYSQL database

Share on | Track this topic | Email this topic | Print this topic
pu8y
post Oct 28 2009, 01:35 PM
Show posts by this member only |This post's rating (0+, 0-) | Post #1


Getting Started
**

Group: Junior Member
Posts: 54
Ratings earned: 0+, 0-
Ratings given: 0+, 0-

Joined: Jun 2006
Hi all,

I am writing a website in ASP.net and database MySQL.
I want to delete the certain records from my database after a number of days, how can I accomplish that?
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
everling
post Oct 28 2009, 02:28 PM
Show posts by this member only |This post's rating (0+, 0-) | Post #2


Enthusiast
*****

Group: Senior Member
Posts: 774
Ratings earned: 0+, 0-
Ratings given: 0+, 0-

Joined: Feb 2008
Configure a scheduled task with Windows Task Scheduler to run a script to do the deletions?
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
pu8y
post Oct 28 2009, 09:47 PM
Show posts by this member only |This post's rating (0+, 0-) | Post #3


Getting Started
**

Group: Junior Member
Posts: 54
Ratings earned: 0+, 0-
Ratings given: 0+, 0-

Joined: Jun 2006
Yes everling you gave me the idea.
I have successfully made it with MySQL event scheduler.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
« Next Oldest · Codemasters · Next Newest »
 

Bump TopicReply to this topicTopic OptionsStart new topic
 



----debug section please ignore----
Lo-Fi Version Time is now: 24th November 2009 - 05:14 AM
All Rights Reserved 2003-2009 Vijandren Ramadass (~living on a prayer~)
Powered by Invision Power Board(Trial) © 2009  IPS, Inc.