Drop user after certain date?

[TOMONYOURMOM]

Hey guys, I am building a website for a robotics club at my school, Each member needs a user in mysql but i dont want to have to go through them every year and manage them. Is there any way that i can set mysql to auto delete that user after 4 years(Freshman,Sophmore,Junior and Senior)? Thanks Alot.

[kicken]

Add a column to store either when they were added, or when they should be removed.  Then you can just compare that date to the current date.  For example:

 

create table users (
  userid int primary key auto_increment
  , username varchar(20)
  , expiresAfter Date
)

 

Then when you add a new user, set the expiresAfter to the current time + 4 years

occ
insert into users (username, expiresAfter)
values ('test', NOW()+INTERVAL 4 YEAR)

 

If you really want you can then setup something to run a DELETE query occasionally but deleteing them is not really necessary.  Just test that field whenever your listing out the users, eg:

SELECT userid, username FROM users WHERE expiresAfter < NOW()

 

[P5system]

You can store user registeration date in database and write a php programm where you will write a delete query checking the records before 4 years and set this file in cron it will run everyday and delete the records automatically