Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- delimiter $$
- MariaDB [test2]> CREATE PROCEDURE leggtil_car2()
- BEGIN
- DECLARE x INT;
- SET x = 1;
- WHILE x <=10 DO
- INSERT INTO Car
- (regno, owner)
- VALUES (floor(RAND() * 9000)+1000, 'ole'+x);
- SET x = x+1;
- END WHILE;
- END$$
- CREATE PROCEDURE leggtil_car3()
- BEGIN DECLARE x INT;
- SET x = 1;
- WHILE x <=10 DO
- INSERT INTO Car
- (regno, owner)
- VALUES (floor(RAND() * 9000)+1000, (select concat('ole', x));
- SET x = x+1;
- END WHILE;
- END$$
- CREATE PROCEDURE add_values_to_subscription()
- BEGIN DECLARE x INT;
- SET x = 1;
- WHILE x <=3000 DO
- INSERT INTO Subscription
- (regno, type)
- VALUES (1000+x, (FLOOR(RAND()*6)+1));
- SET x = x+1;
- END WHILE;
- END$$
- CREATE PROCEDURE add_values_to_passing()
- BEGIN DECLARE x INT;
- SET x = 1;
- WHILE x <=100000 DO
- INSERT INTO Passing
- (regno, timestamp, station)
- VALUES ((FLOOR(RAND() *4000)+1000), (FROM_UNIXTIME(UNIX_TIMESTAMP('2015-01-01 00:00:00') + FLOOR(RAND() * 63072000))),(FLOOR(RAND()*10)+1));
- SET x = x+1;
- END WHILE;
- END$$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement