Mh3gsftm

1CREATE TABLE IF NOT EXISTS `pb2_pb`.`Spored` (
2  `ID_Spored` INT NOT NULL,
3  `datumPredvajanja` DATETIME NOT NULL,
4  `casPredvajanja` DATETIME NOT NULL,
5  `aktualno` VARCHAR(45) NOT NULL
6)
7ENGINE = InnoDB;
8	
9DELIMITER //
10CREATE PROCEDURE polni_spored (st_sporeda INT)
11    BEGIN
12        DECLARE datum_predvajanja DATETIME;
13        DECLARE cas_predvajanja DATETIME;
14        DECLARE aktualno VARCHAR(45);
15        DECLARE stevec INT;
16        DECLARE konecVal INT;
17
18        SET stevec = 0;
19        SET konecVal = st_sporeda;
20
21        WHILE (stevec < konecVal) DO
22            SET datum_predvajanja = (SELECT DATE_FORMAT(FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()) + FLOOR(0 + (RAND() * 63072000))), '%Y-%m-%d'));
23            SET cas_predvajanja = NOW() - INTERVAL FLOOR(RAND() * 1000) DAY;
24            SET aktualno = "DA";
25
26            INSERT INTO `pb2_pb`.`Spored` (`datumPredvajanja`, `casPredvajanja`, `aktualno`) VALUES ('datum_predvajanja', 'cas_predvajanja', CONCAT(aktualno, (stevec + 1)));
27
28            SET stevec = stevec + 1;
29        END WHILE;
30    END //
31
32DELIMITER ;
33	
34INSERT INTO `pb2_pb`.`Spored` (`datumPredvajanja`, 
35                                       `casPredvajanja`, 
36                                       `aktualno`) 
37                               VALUES (datum_predvajanja, 
38                                       cas_predvajanja, 
39                                       CONCAT(aktualno, (stevec + 1)));