SQL - Como se hace esto? alguna manera similar? procedimiento consulta

SET @cartName = cartName;

SET @getTable1 =

  CONCAT("SELECT COUNT(*) INTO @deletedCount FROM `",

        REPLACE(tableName, '`', '``'),

        "` WHERE cartType=? AND deleted='1'");

PREPARE stmt1 FROM @getTable1;

EXECUTE stmt1 USING @cartName;

delimiter //

CREATE PROCEDURE pruebaset(IN origen VARCHAR(20))

BEGIN

DECLARE cont int(100);

set @sentencia = concat("select count(*) as cont from ",origen,".prueba "); -> esta query devuelve cont con 5000

prepare smt from @sentencia;

execute smt;

if @cont > 0 then

set @sentencia2 = concat("select * from ",origen,".prueba2 ");

prepare smt2 from @sentencia2;

execute smt2;

end if;

END//

delimiter ;

delimiter //

CREATE PROCEDURE pruebaset(IN origen VARCHAR(20))

BEGIN

set @cont = 0;

set @sentencia = concat("select count(*) into @cont from ",origen,".prueba");

prepare smt from @sentencia;

execute smt;

if @cont > 0 then

set @sentencia2 = concat("select * from ",origen,".prueba2 ");

prepare smt2 from @sentencia2;

execute smt2;

end if;

END//

delimiter ;