fgzG4yx8

1CREATE TABLE STATS (
2STAT_ID INT(11) AUTO_INCREMENT PRIMARY KEY,
3STAT_DATE DATETIME NOT NULL,
4STAT VARCHAR(20) NOT NULL,
5VALUE INT(11) NOT NULL
6);
7
8
9CREATE VIEW BESTSELLERS_COUNT AS SELECT SUM(BESTSELLER) FROM BOOKS; 
10
11
12DELIMITER $$
13
14CREATE EVENT IF NOT EXISTS BESTSELLER_STATS ON SCHEDULE EVERY 1 MINUTE DO 
15BEGIN
16CALL UpdateBestSellers();
17INSERT INTO STATS(STAT_DATE, STAT, VALUE) 
18VALUES(CURDATE(), "BESTSELLERS", (SELECT * FROM BESTSELLERS_COUNT));
19END $$
20
21DELIMITER ;