Skip to content

Instantly share code, notes, and snippets.

@pixelpylon
Created August 18, 2020 18:46
Show Gist options
  • Save pixelpylon/75300520acfebdab97c97e4bf539520b to your computer and use it in GitHub Desktop.
Save pixelpylon/75300520acfebdab97c97e4bf539520b to your computer and use it in GitHub Desktop.
BEGIN
DECLARE startingRange INT DEFAULT 1;
WHILE startingRange <= 100 DO
SET FOREIGN_KEY_CHECKS=0;
INSERT INTO `user_tour_qualification` (`id`, `user_id`, `tour_qualification_id`, `created_at`, `updated_at`) VALUES (startingRange, startingRange, '9', '2020-08-18 00:00:00', '2020-08-18 00:00:00');
SET startingRange = startingRange + 1;
SET FOREIGN_KEY_CHECKS=1;
END WHILE;
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment