MySQL: How do a i insert a specific number of blank rows into a table

Question

I want to grab a variable (between 1-365) and use this value to create the number of empty rows in a table:

insert into tblCustomer (ID) values (), (), ();

is there an easier way to do this or is using a loop the best way?

Any help would be appreciated.

You should probably look here http://stackoverflow.com/questions/17673549/sql-select-a-list-of-numbers-from-nothing — Lubos Horacek, May 06 '16 at 10:42

Mihai · Accepted Answer · 2016-05-06T10:24:24.787

2

A procedure with an IN parameter is quite easy

 DELIMITER $$
 DROP PROCEDURE IF EXISTS test_loop$$
 CREATE PROCEDURE test_loop(IN number INT)
 BEGIN
 DECLARE x  INT(11);

 SET x = 1;    

 WHILE x  <= number  DO
 INSERT INTO tblCustomer(id)  VALUES('');
 SET  x = x + 1; 
 END WHILE;

 END$$
DELIMITER ;

How to use it

CALL test_loop(20);

edited May 06 '16 at 10:24

answered May 06 '16 at 10:18

Mihai

26,325
7
66
81

MySQL: How do a i insert a specific number of blank rows into a table

1 Answers1