[Solved] MySql Trigger Function about status
If you are looking for an update statement that you would run periodically, and that sets the status of newly expired items, that would be: update orders set status=”expired” where curent_date > expired_date and status=”new” On the other hand… In your schema, status is a derived information, that is a column whose value can be … Read more