mysql遍历过程中被删除_mysql遍历所有表，删除符合条件的记录的存储过程 | 学步园...

DELIMITER $$

DROP FUNCTION IF EXISTS `gtonline`.`func_delgroups`$$

CREATE FUNCTION `gtonline`.`func_delgroups`(ngrpid INT )

RETURNS INT

/*LANGUAGE SQL

| [NOT] DETERMINISTIC

| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }

| SQL SECURITY { DEFINER | INVOKER }

| COMMENT 'string'*/

BEGIN

DECLARE xid INT default 0;

delete from t_groupsinfo where ID=ngrpid;

delete from t_groupsuser where GroupID=ngrpid;

return 0;

END$$

DELIMITER ;