Advertisement
Guest User

Untitled

a guest
Feb 20th, 2015
461
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
DCS 1.00 KB | None | 0 0
  1. delimiter $$
  2. MariaDB [test2]> CREATE PROCEDURE leggtil_car2()
  3. BEGIN
  4. DECLARE x INT;
  5. SET x = 1;
  6. WHILE x <=10 DO
  7. INSERT INTO Car
  8. (regno, owner)
  9. VALUES (floor(RAND() * 9000)+1000, 'ole'+x);
  10. SET x = x+1;
  11. END WHILE;
  12. END$$
  13.  
  14.  
  15. CREATE PROCEDURE leggtil_car3()
  16. BEGIN DECLARE x INT;
  17. SET x = 1;
  18. WHILE x <=10 DO
  19. INSERT INTO Car
  20. (regno, owner)
  21. VALUES (floor(RAND() * 9000)+1000, (select concat('ole', x));
  22. SET x = x+1;
  23. END WHILE;
  24. END$$
  25.  
  26. CREATE PROCEDURE add_values_to_subscription()
  27. BEGIN DECLARE x INT;
  28. SET x = 1;
  29. WHILE x <=3000 DO
  30. INSERT INTO Subscription
  31. (regno, type)
  32. VALUES (1000+x, (FLOOR(RAND()*6)+1));
  33. SET x = x+1;
  34. END WHILE;
  35. END$$
  36.  
  37. CREATE PROCEDURE add_values_to_passing()
  38. BEGIN DECLARE x INT;
  39. SET x = 1;
  40. WHILE x <=100000 DO
  41. INSERT INTO Passing
  42. (regno, timestamp, station)
  43. VALUES ((FLOOR(RAND() *4000)+1000), (FROM_UNIXTIME(UNIX_TIMESTAMP('2015-01-01 00:00:00') + FLOOR(RAND() * 63072000))),(FLOOR(RAND()*10)+1));
  44. SET x = x+1;
  45. END WHILE;
  46. END$$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement