这是用特定时间段更新MySQL表的正确方法

Question

I am updating my MySQL table with specific time. What actually happening is - payment status is unpaid and it will automatic cancel after 15 mins. but only specific payment status, who is older than 15 mins should be cancel.

i am trying to update mysql table entry only in specific time like 15 min.

$sql = "UPDATE payers SET payment_status='Cancel' WHERE 
payment_status=unpaid >= NOW() - INTERVAL 15 MINUTE"; 
if(mysqli_query($conn, $sql)){ 
echo "Record was updated successfully."; 
} else { 
echo "ERROR: Could not able to execute $sql. "  
. mysqli_error($conn); 
}  
mysqli_close($$conn); 

payment_status need to update only when unpaid is older than 15 mins.

Answer 1

This SQL should work for you:

UPDATE payers
SET payment_status='Cancel'
WHERE payment_status='unpaid'
  AND payment_time <= NOW() - INTERVAL 15 MINUTE

However, this has hidden problem: what if someone pays exactly after 15 min of order submission? They would have paid, but you wouldn't send them your goods.