DELIMITER $$
DROP PROCEDURE IF EXISTS `abc`.`myuserproc` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `myuserproc`()
BEGIN
declare regno,employeeid bigint;
declare x int;
set regno=18;
set employeeid=603177;
set x=1;
while x<=5
do
insert into userdetails values('bharat_m',regno,'infosys','2012-03-20',employeeid);
set regno=regno+1;
set employeeid=employeeid+1;
set x=x+1;
end while;
END $$
DELIMITER ;
goodBhai reddy June 28, 2011 at 3:11 PM
nice code.........and good way 2 understood
sdfpiyush September 18, 2011 at 12:59 PM
it's not working
javaDashrath October 9, 2011 at 7:14 PM
your site is best of study
insert using store procedureDharmveer January 20, 2012 at 2:11 AM
i want insert data in mysql using store procedure.....i am using wamp server
while loop in stored procedurebharat March 20, 2012 at 9:57 PM
DELIMITER $$ DROP PROCEDURE IF EXISTS `abc`.`myuserproc` $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `myuserproc`() BEGIN declare regno,employeeid bigint; declare x int; set regno=18; set employeeid=603177; set x=1; while x<=5 do insert into userdetails values('bharat_m',regno,'infosys','2012-03-20',employeeid); set regno=regno+1; set employeeid=employeeid+1; set x=x+1; end while; END $$ DELIMITER ;
.netlokesh March 26, 2012 at 12:05 PM
question
NothingJohn Wardan December 19, 2012 at 11:19 AM
Dude
Post your Comment