DROP PROCEDURE IF EXISTS `USP_LoadConfigTable`$$
CREATE DEFINER=`admin`@`%` PROCEDURE `USP_LoadConfigTable`(v_TableName VARCHAR(64))
BEGIN
DECLARE v_stat VARCHAR(200);
SET @v_stat=CONCAT('select * from ',v_TableName);
PREPARE SelectConfigTable FROM @v_stat;
EXECUTE SelectConfigTable;
END$$
DELIMITER ;
页:
[1]