Ranka Rankarusu

☕

stuck in vim

we(e)bdev

Rankarusu / generateData.sql

Created July 9, 2025 08:56

Generate lots of data in MySQL

	drop procedure if exists doWhile;
	SET autocommit=0;
	SET unique_checks=0;
	SET foreign_key_checks=0;

	DELIMITER //
	CREATE PROCEDURE doWhile()
	BEGIN
	DECLARE i INT default 1;
	WHILE (i <= 15000000) DO