/* MySQL - 5.0.51b-community-nt-log : Database - test ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`test` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */; USE `test`; /* Procedure structure for procedure `testSP` */ /*!50003 DROP PROCEDURE IF EXISTS `testSP` */; DELIMITER $$ /*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `testSP`() BEGIN select 10*rand(); END */$$ DELIMITER ; /*!50003 DROP PROCEDURE IF EXISTS `testSP2` */; DELIMITER $$ /*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `testSP2`() BEGIN select 100*rand(); END */$$ DELIMITER ; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;