mysql存储过程

1.查询存储过程

DELIMITER $$

USE `shiguoliang`$$

DROP PROCEDURE IF EXISTS `GETUSER`$$

CREATE DEFINER=`root`@`%` PROCEDURE `GETUSER`()
	BEGIN
		SELECT * FROM t_user;
	END$$

DELIMITER ;

2.删除存储过程

DELIMITER $$

USE `shiguoliang`$$

DROP PROCEDURE IF EXISTS `DE`$$

CREATE DEFINER=`root`@`%` PROCEDURE `DE`()
	BEGIN
		delete FROM t_user WHERE ID=7;
	END$$

DELIMITER ;

3.插入存储过程

DELIMITER $$

USE `shiguoliang`$$

DROP PROCEDURE IF EXISTS `INSER`$$

CREATE DEFINER=`root`@`%` PROCEDURE `INSER`()
	BEGIN
		INSERT INTO t_user VALUES(7,'WWW','777777');
	END$$

DELIMITER ;

4.修改存储过程

DELIMITER $$

USE `shiguoliang`$$

DROP PROCEDURE IF EXISTS `UPDA`$$

CREATE DEFINER=`root`@`%` PROCEDURE `UPDA`()
	BEGIN
		UPDATE t_user set name='wwwwww' where id=6;
	END$$

DELIMITER ;

5.访问存储过程

CALL GETUSER();
CALL DE();
CALL INSER();
CALL UPDA();

这些只是基本的存储过程！

6.while循环存储过程

DELIMITER $$

USE `shiguoliang`$$

DROP PROCEDURE IF EXISTS `pro`$$

CREATE DEFINER=`root`@`%` PROCEDURE `pro`()
    BEGIN
	declare i int;
	set i=0;
	while i<5 
	do
	insert into t1(fild)values(i);
	set i=i+1;
	end while;
    END$$

DELIMITER ;