I have a table with the following structure:
tb_simulation:
id(INT) | codigo(VARCHAR) | flag_valido(INT) | data_hora(DATETIME) | valor(DEC)
I would like five minutes after the registry was entered the database automatically changed the value from flag_valido
to 1. How could I do this? I researched some topics but found nothing that could solve my problem.