CREATE DEFINER=`root`@`localhost` PROCEDURE `insert100records`() begin DECLARE i INT DEFAULT 1; declare j int; declare name varchar(15); WHILE i <= 100 DO set j=20+i; set name='REG' + cast(j AS char(2))+'2017'; SELECT name; SET i = i + 1; END WHILE; end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)