Is it possible to auto change a value after an experation date of a year in MYSQL? -
i have value in row in database needs change automatically 1 0 after year. possible? if so, please redirect me easy understand link explanation how done or explain me how done? i'm beginning , know little. thank you.
check mysql event: http://dev.mysql.com/doc/refman/5.7/en/create-event.html
example
create event myevent on schedule @ current_timestamp + interval 1 hour update myschema.mytable set mycol = mycol + 1;
Comments
Post a Comment