Data deletion and modification (MySQL)

// The deletion update time is empty and the creation time is 5 Data from days ago

DELETE FROM eqmt_order WHERE eqmt_order.update_time IS NULL AND DATE(eqmt_order.create_time) <= DATE(DATE_SUB(NOW(),INTERVAL 5 DAY));

// Deletion duration is less than 0.2 All data for

DELETE FROM eqmt_order WHERE eqmt_order.duration<0.2

// Delete the test data of the specified user

DELETE FROM eqmt_order WHERE eqmt_order.uid=71 OR eqmt_order.uid=4 OR eqmt_order.uid=3 OR eqmt_order.uid=2 OR eqmt_order.uid=1

// Update order usage duration and keep 2 Decimal place

UPDATE eqmt_order SET duration = ROUND(TIMESTAMPDIFF(MINUTE,eqmt_order.create_time,eqmt_order.update_time)/60,2)

// Update the reservation table by association

UPDATE eqmt_equipment,eqmt_reserve SET is_hot=1 WHERE eqmt_equipment.id=eqmt_reserve.equipment_id AND eqmt_reserve.`status`=1

// Update the actual order usage time and keep it 2 Decimal place

UPDATE eqmt_order SET duration = ROUND(TIMESTAMPDIFF(MINUTE,eqmt_order.create_time,eqmt_order.reset_time)/60,2)where eqmt_order.reset_time IS NULL