Pozdrav svima, zanima me dali je moguće i kako da baza automatski promijeni u mom slučaju active u ‘0’ kada prođe određeni datum (date_time) ? Ili se to radi preko npr. php-a?
+-------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+----------------+
| date_activated | datetime | YES | | NULL | |
| date_end | datetime | YES | | NULL | |
| active | tinyint(1) | NO | | NULL | |
+-------------------+--------------+------+-----+---------+----------------+