I'd like (if it possible) check a time and if time = special time, make update of the table.
My idea:
select current_time()
if current_time = 15:19
{
update tasks set finished = replace (finished, '1', '0')
}
Do you have any ideas???
Add a comment
|
1 Answer
Use an event for that
delimiter //
CREATE EVENT IF NOT EXISTS your_event
ON SCHEDULE EVERY 1 DAY
STARTS '2014-07-04 15:19:00'
ON COMPLETION PRESERVE ENABLE
DO
update tasks
set finished = replace (finished, '1', '0');
//
It will be executed automatically every day on the defined time.
3 Comments
Mc Doc
Ok! Thanks, but I will add this part of code to website on the PHP. How bind for PHP?
Mc Doc
$sql = mysqli_query($con, "CREATE EVENT IF NOT EXISTS your_event ON SCHEDULE EVERY 1 DAY STARTS '2014-07-04 15:19:00' ON COMPLETION PRESERVE ENABLE DO update tasks set finished = replace (finished, '1', '0')"); is it true?
Mc Doc
Look - s1.radikali.ru/uploads/2014/7/4/… - Finished has 3 row - Did query - s1.radikali.ru/uploads/2014/7/4/… - and check a table - s1.radikali.ru/uploads/2014/7/4/… - Finished the same (((
