AKZN Notes

Archives for My Lazy and Forgetful Mind

Tag: procedure

RANDOM DATA Table Order

[MYSQL][PROCEDURE] RANDOM DATA Table Order tb_order DELIMITER $$ DROP PROCEDURE IF EXISTS make_order$$ CREATE PROCEDURE make_order () BEGIN DECLARE monthcounts INT DEFAULT 1; DECLARE daycounts INT DEFAULT 1; DECLARE orderbydaycounts INT DEFAULT 1; WHILE monthcounts < 9 DO SET daycounts = 1; WHILE daycounts < 31 DO SET orderbydaycounts = 1; WHILE orderbydaycounts < 5 […]