MySQL
SELECT COUNT(*) ,FOUND_ROWS() FROM `inventory` WHERE film_id = '930' LIMIT 10 el SMALLINT te ira en -32768 a 32767. Pero si lo pones con unsigned, sera desde 0 a 65535 (porque no toma el valor negativo). DELIMITER $$ USE `sakila`$$ DROP PROCEDURE IF EXISTS `rewards_report`$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `rewards_report`( IN min_monthly_purchases TINYINT UNSIGNED , IN min_dollar_amount_purchased DECIMAL(10,2) UNSIGNED , OUT count_rewardees INT ) READS SQL DATA COMMENT 'Provides a customizable report on best customers' proc: BEGIN DECLARE last_month_start DATE; DECLARE last_month_end DATE; /* Some sanity checks... */ IF min_monthly_purchases = 0 THEN SELECT 'Minimum monthly purchases parameter must be > 0'; LEAVE proc; END IF; IF mi...