Re: Update column when datetime = NOW()
Posted by:
Trevor Pan
Date: February 20, 2020 12:08PM
Hi Peter,
It may be true that the boolean column "bidded" may be redundant - I appreciate that observation. Currently, I'm using the "bidded" column to provide an exists condition in php and the views. e.g. $bidded = $job->complete();.
This queries the bidded column.
Removing the bidded column may be a refactor I need to do...although I think it is very tidy to be able to have a bidded status column as the site uses a non-relational js search feature.
The issue still remains: how create a mysql event (or equivalent name/method in mysql as compared to laravel) when the deadline column timestamp is = NOW().
As mentioned in the original post, a cron job could achieve this outcome, but it would be based on larger intervals not at the exact moment when an existing column timestamp = NOW()
Does that help ?
Subject
Written By
Posted
February 18, 2020 07:52AM
February 18, 2020 12:38PM
February 20, 2020 08:12AM
February 20, 2020 09:34AM
February 20, 2020 10:37AM
February 20, 2020 11:32AM
Re: Update column when datetime = NOW()
February 20, 2020 12:08PM
February 20, 2020 03:39PM
February 20, 2020 03:47PM
February 20, 2020 04:49PM
February 20, 2020 05:19PM
February 20, 2020 08:36PM
February 22, 2020 03:59PM
February 22, 2020 06:26PM
February 20, 2020 08:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.