Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automating MySQL updates...

Status
Not open for further replies.
buzzt

buzzt

Programmer
Oct 17, 2002
171
CA
Does anyone know how I could have a mysql table automatically delete a row based on the date? For example, if a user entered into a database has not activated his/her account with in one day, the user is automatically deleted.

What would be the best approach?
 
Sort by date Sort by votes
Garbage collection.

Create a program which looks in the database and delete unactivated records that are more than 24 hours hold. Have some automation utility (like cron on *nix) run that program hourly. ______________________________________________________________________
TANSTAAFL!
 
Upvote 0 Downvote
Any idea what I could use on Windows?
 
Upvote 0 Downvote
Which version of Win32? ______________________________________________________________________
TANSTAAFL!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
465
EdZzy
E
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
576
spamjim
spamjim
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
786
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
700
Chris Miller
Chris Miller
dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
791
dylim
dylim

Part and Inventory Search

Sponsor

Back
Top