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