JavaScript Example:
CREATE TABLE event_log (
event_id INT AUTO_INCREMENT PRIMARY KEY,
event_name VARCHAR(255),
event_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
INSERT INTO event_log (event_name) VALUES ('User Login');
INSERT INTO event_log (event_name) VALUES ('Product Purchase');
INSERT INTO event_log (event_name) VALUES ('Payment Completed');
INSERT INTO event_log (event_name) VALUES ('User Logout');
SELECT event_name, event_timestamp
FROM event_log
WHERE event_timestamp >= DATE_SUB(NOW(), INTERVAL 1 HOUR);
SELECT event_name, event_timestamp
FROM event_log
WHERE event_timestamp BETWEEN '2023-10-26 10:00:00' AND '2023-10-26 11:00:00';
SELECT event_name, event_timestamp
FROM event_log
ORDER BY event_timestamp DESC
LIMIT 1;
Back to Home