MySQL Forums
Forum List  »  PHP

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 ?

Options: ReplyQuote


Subject
Written By
Posted
Re: Update column when datetime = NOW()
February 20, 2020 12:08PM


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.