MySQL Event Schedule Datediff

Asked Apr 05 '20 at 06:58

Active Apr 05 '20 at 06:58

Viewed 65 times

When i try to execute this SQL, i got an error, bellow :

SQL Query :

CREATE EVENT fine
ON SCHEDULE
EVERY 1 DAY
DO
if datediff(CURRENT_DATE,transactions.return_date) > 0
UPDATE transactions SET fine = fine + 1000
end if

ERROR : #1054 - Unknown column 'return_date' in 'field list'

and here my transactions table columns :

Please anyone help me, much thanks!!

asked Apr 05 '20 at 06:58

mrobbizulfikar

1

You have to select return_date and and if must have a then and there should ONLY be an update statement anyway. Write a working update statement then put it into an event. – P.Salmon Apr 05 '20 at 07:17
can you give me some example sir? – mrobbizulfikar Apr 05 '20 at 07:28
1

https://dev.mysql.com/doc/refman/8.0/en/update.html – P.Salmon Apr 05 '20 at 07:29
Not if, WHERE.. – P.Salmon Apr 05 '20 at 07:57
ohh its DONE by : CREATE EVENT fine ON SCHEDULE EVERY 1 MINUTE DO UPDATE transactions SET fine = IF(datediff(CURRENT_DATE,return_date) > 0, fine + 1000,fine+0) THANK YOU @P.Salmon – mrobbizulfikar Apr 05 '20 at 07:58

0 Answers0