To make an overall quick update on the ERM Database to products minimum, maximum and total number allow per day use the following SQL QUERY.
UPDATE producteventdate
SET mintickets= "2"
WHERE productid=49 and date > "2019-12-31";To make an overall quick update on the ERM Database to products minimum, maximum and total number allow per day use the following SQL QUERY.
UPDATE producteventdate
SET mintickets= "2"
WHERE productid=49 and date > "2019-12-31";