DROP TABLE IF EXISTS `dbteste`.`usuarios`; CREATE TABLE `dbteste`.`usuarios` ( `codigo` int(10) unsigned NOT NULL auto_increment, `nome` varchar(45) NOT NULL, `email` varchar(45) NOT NULL, PRIMARY KEY (`codigo`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
------------------------------
DELIMITER $$ DROP PROCEDURE IF EXISTS `dbteste`.`sp_total_usuarios` $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_total_usuarios`(OUT total int) BEGIN SELECT COUNT(*) INTO total FROM usuarios; END $$ DELIMITER;
-------------------------------
CALL sp_total_usuarios(@total); SELECT @total;
obs tem 10 registros na tabela