Checking if select statement in stored procedure returns string
How to check if a select statement inside a stored procedure returns any rows.
select * from creditcards;
If sqlcod = 0 THEN
I would like to do something like this, for example, but sqlcod does not work in MySql.
+3
EMChamp
source
to share
2 answers
try using COUNT
,
DELIMITER $$
CREATE PROCEDURE procName()
BEGIN
SET @recCount = (select count(*) from creditcards);
If @recCount = 0 THEN
-- statement here ;
END IF;
END $$
DELIMITER ;
+7
John Woo
source
to share
Try using as below:
Use FOUND_ROWS()
and SQL_CALC_FOUND_ROWS
:
DELIMITER $$
create procedure myproc()
begin
SELECT SQL_CALC_FOUND_ROWS *
FROM tbl_name
WHERE id > 100
LIMIT 10;
if SELECT FOUND_ROWS() = 0 then
-- log away bro!
end if;
end $$
DELIMITER $$
+1
user2001117
source
to share