Tasks - Conditions and Loops #11

akash-coded · 2022-03-16T04:46:34Z

akash-coded
Mar 16, 2022
Maintainer

Conditional and Looping Statements in MySQL

Write a stored procedure that takes an INT as input and returns the factorial of the number, if the number is prime. Else, it returns a comma-separated string of the divisors of the number.
Example:
- Input = 5, Output = 120
- Input = 4, Output = "1, 2, 4, "
Write a stored procedure that takes an INT as input and returns "YES" if the number is pallindrome or "NO" if the number is not pallindrome.
Example:
- Input = 141, Output = "YES"
- Input = 123, Output = "NO"

lalit-ky · 2022-03-16T05:46:00Z

lalit-ky
Mar 16, 2022

Write a stored procedure that takes an INT as input and returns the factorial of the number, if the number is prime. Else, it returns a comma-separated string of the divisors of the number.

Example:

Input = 5, Output = 120

Input = 4, Output = "1, 2, 4, "

DELIMITER //

CREATE PROCEDURE getFactOfPrime(
	IN number INT
)
BEGIN
    DECLARE x INT;
    DECLARE fact INT;
    DECLARE str VARCHAR(225);
    SET x = 1;
    SET fact = 1;
    SET str = "1, ";
    WHILE x<number-1 
    DO
        SET x = x+1;
        SET fact = fact*x;
        IF(number mod x = 0) 
        THEN
            SET fact = 0;
            SET str = CONCAT(str,x,", ");
        END IF;
    END WHILE;
    SET fact = fact*number;
    SET str = CONCAT(str,number);
    IF(fact=0)
    THEN
        SELECT str;
    ELSE
        SELECT fact;
    END IF;
END //

DELIMITER ;

CALL getFactOfPrime(5);

Write a stored procedure that takes an INT as input and returns "YES" if the number is pallindrome or "NO" if the number is not pallindrome.

Example:

Input = 141, Output = "YES"

Input = 123, Output = "NO"

DELIMITER //

CREATE PROCEDURE isPalindrome(
	IN number INT,
    OUT str VARCHAR(4)
)
BEGIN
    DECLARE digit INT;
    DECLARE reverse INT;
    DECLARE copy INT;
    SET copy = number;
    SET digit = 0;
    SET reverse = 0;
    WHILE(number>0)
    DO
        SET digit = number mod 10;
        SET reverse = reverse*10+digit;
        SET number = number/10;
    END WHILE;
    IF reverse = copy
    THEN
        SET str = "YES";
    ELSE 
        SET str = "NO";
    END IF;

END//

DELIMITER ;

CALL isPalindrome(12321,@ans);
SELECT @ans;

0 replies

Khyati-tripathi · 2022-03-16T05:57:09Z

Khyati-tripathi
Mar 16, 2022

--1
DELIMITER //
CREATE PROCEDURE prime(IN n INT) BEGIN
DECLARE i,flag INT;
DECLARE str VARCHAR(255);
set str = '1,';
SET i = 2,
    flag = 1;
while i < n do
SET flag =flag*i;
 if(n %i = 0) then
SET flag =0;
SET str= CONCAT(str,i,',');
END IF;
SET i = i + 1;
END WHILE;
if (flag >1) THEN
SELECT flag*n as factorial;
else
SELECT str as divisors;
END IF;
END //
DELIMITER;

--palindrome
DELIMITER / / CREATE PROCEDURE palindrome(IN n INT, INOUT res VARCHAR(10)) BEGIN
DECLARE x,
    r,
    t INT;
SET x = n;
SET t = 0;
while x > 0 do
SET r = x %10;
SET t =(t * 10) + r;
SET x = x div 10;
end while;
IF (t = n) THEN
SET res = 'YES';
ELSE
SET res = 'NO';
END IF;
END / / DELIMITER;
call palindrome(454, @res);
select @res;

0 replies

ratnadeepikavuddagiri · 2022-03-16T06:12:31Z

ratnadeepikavuddagiri
Mar 16, 2022

DELIMITER //
CREATE PROCEDURE getFactorial(
        IN num INT,
	OUT str varchar(255),
	OUT fact int
)
BEGIN
	declare flag int;
	declare i int;
	set flag = 1;
	set i = 2;
	set str="1";
	While i<num
	do
		if(num mod i = 0) then
			set flag = 0;
			set str = concat(str,", ",i);
		end if;
		Set i = i+1;
	End while;
	set fact =1;
	if(flag=1) then
		while(num>0) do
			set fact = fact*num;
			set num = num-1;
		end while;
		select fact;
        else
                select str;
	end if; 	
END //
delimiter ;

call getFactorial(5,@str,@fact);

delimiter //
CREATE PROCEDURE checkPalindrome(
	IN num INT,
        OUT str varchar(255)       
)
BEGIN
	declare temp int;
	declare rev int;
	set rev=0;
	set temp =num;
        while(temp>0) do
		set rev = rev*10 + (temp mod 10);
		set temp = temp/10;
	end while;
	if rev=num then
		set str ="YES";
	else
		set str = "NO";
	end if;
END //
delimiter ;

call checkPalindrome(141,@result);
select result;

0 replies

Sarfinaa · 2022-03-16T06:17:54Z

Sarfinaa
Mar 16, 2022

-- 1.)
-- For finding prime
create procedure prime(in num int,out res int,out sres varchar(30))
begin 
declare i int default 2;
declare c int default 0;
set res=1;
set sres='1';
while(i<=num) do 
if(num mod i=0) then set c=c+1;
set sres=concat(sres,',',i);
end if;
set i=i+1;
end while;
if(c>2) then set res=0;
end if;
end //
-- For factorial 
create procedure fact(in num int)
begin 
declare prod int default 1;
call prime(num,@res,@sres);
if(@res=1) then
while(num<>0) do   
 set prod=num*prod;
 set num=num-1;
 end while;
select prod; 
else select @sres; 
end if;
 end //
-- 2.) 
create procedure palin(in n int, inout res varchar(10))
 begin 
declare x,r,rev int;
set x = n;
set rev = 0;
while x > 0 do
set r = x %10;
set rev =(rev * 10) + r;
set x = x div 10;
end while;
if (rev = n) then
set @res = 'YES';
else
set @res = 'NO';
end if;
select @res;
end //

0 replies

abhiraj2k · 2022-03-16T06:39:36Z

abhiraj2k
Mar 16, 2022

CREATE PROCEDURE fact(IN num INT)
BEGIN
DECLARE ans INT;
DECLARE i INT;
DECLARE ansStr VARCHAR(300);
DECLARE isPrimeFlag INT;
SET isPrimeFlag = 1;
SET ans = 1;
SET i = 2;
SET ansStr = "1, ";

myloop: WHILE(i <= num/2) 
DO
    IF(num mod i = 0) THEN
        SET isPrimeFlag = 0;
        LEAVE myloop;
    END IF;
    SET i = i+1;
END WHILE myloop;
SET i = 1;
IF(isPrimeFlag = 1) THEN

    WHILE(i <= num) 
    DO
        SET ans = ans * i;
        SET i = i + 1;
    END WHILE;
ELSE 
    WHILE(i <= num/2) DO
        IF(num mod i = 0) THEN
        SET ansStr =  CONCAT(ansStr, i, ", ");
        END IF;
        SET i = i+1;
    END WHILE;
END IF;
SELECT num AS Input_Number, ans AS Prime_Factorial, ansStr AS Answer;
END

CREATE PROCEDURE isPalindrome(IN num INT)
BEGIN
DECLARE numReversed INT;
DECLARE i INT;
DECLARE temp INT;
DECLARE ans VARCHAR(3);
SET temp = num;
SET numReversed = 0;
SET i = 0;
WHILE(temp > 0)
DO
    SET numReversed = (numReversed * 10) + (temp % 10);
    SET temp = temp/10;
END WHILE;
IF(num = numReversed) THEN
    SET ans = "YES";
ELSE
    SET ans = "No";
END IF;
SELECT num AS NUM, ans as ANSWER;
END

0 replies

Ashwesh09 · 2022-03-16T07:28:45Z

Ashwesh09
Mar 16, 2022

Conditional and Looping Statements in MySQL

Write a stored procedure that takes an INT as input and returns the factorial of the number, if the number is prime. Else, it returns a comma-separated string of the divisors of the number.
Example:

Input = 5, Output = 120

Input = 4, Output = "1, 2, 4, "

DELIMITER //

CREATE PROCEDURE isPrime(IN x INT(11),
    OUT outputIs INT
)
BEGIN
    SET outputIs = 1;
    IF x < 2 THEN
        SET outputIs = 0;
    ELSE
        SET @i = x - 1;
        WHILE @i >= 2
        DO
            IF(x mod @i = 0) THEN
                SET outputIs = 0;
            END IF;
        SET @i = @i - 1;
        END WHILE;
    END IF;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE printDivisor(IN x INT(11))
BEGIN
    DECLARE i INT;
    DECLARE str VARCHAR(255) DEFAULT '';

    SET i = 1;
    WHILE (i <= x)
    DO
        IF (x mod i = 0) THEN
            SET str = CONCAT(str,i, ', ');
        END IF;
        SET i = i + 1;
    END WHILE;
    SELECT str;
END //

DELIMITER ;

DELIMITER // 
CREATE PROCEDURE mainProcess(
    IN x INT(11)
)
BEGIN
    SET @temp = x;
    CALL isPrime(@temp,@outputIs);
    IF (@outputIs = 1) THEN
        WHILE @temp <> 1 DO
            SET @temp = @temp - 1;
            SET x = x * (@temp);
        END WHILE;
        SELECT x;
    ELSE
        CALL printDivisor(@temp);
    END IF;
END//

DELIMITER ;

CALL mainProcess(5);
CALL mainProcess(4);

Write a stored procedure that takes an INT as input and returns "YES" if the number is pallindrome or "NO" if the number is not pallindrome.
Example:

Input = 141, Output = "YES"

Input = 123, Output = "NO"

DELIMITER //
CREATE PROCEDURE isPalindrome(IN num INT(11), OUT str VARCHAR(5)
)
BEGIN
    DECLARE temp VARCHAR(20);
    DECLARE rev VARCHAR(20);
    SET temp = num;
    SET rev = '';
    WHILE (num > 0) 
    DO
        SET rev = CONCAT(rev,num mod 10);
        SET num = num / 10;
    END WHILE;
    IF rev = temp THEN
        SET str = "YES";
    ELSE
        SET str = "NO";
    END IF;
END//

DELIMITER ;

call isPalindrome(141,@ans);
Select @ans;
call isPalindrome(123,@ans);
Select @ans;

0 replies

Harshita-Joshi · 2022-03-16T08:17:56Z

Harshita-Joshi
Mar 16, 2022

1

DELIMITER //

CREATE PROCEDURE PrimeDivisor(IN n INT)
BEGIN

    DECLARE i INT;
    DECLARE resPrime INT;
    DECLARE res1 INT;
    DECLARE res2 VARCHAR(255);

    SET i = 2;
    SET resPrime = 1;

    WHILE i < n DO
        IF (n % i = 0) THEN
        SET resPrime = 0;
        END IF;
        SET i = i+1;
    END WHILE;
    
    IF resPrime = 1 THEN
        SET res1=1;
        SET i = 1;
        WHILE i <= n DO
            SET res1 = res1*i;
            SET i = i+1;
        END WHILE;
        
    
    ELSE 
        SET res2 = "";
        SET i = 1;
        WHILE i <= n DO
            IF (n % i = 0) THEN
            SET res2 = CONCAT(res2, i, ", ");
            END IF;
            SET i = i+1;
        END WHILE;
    END IF;

    IF resPrime = 1 THEN
    SELECT res1;
    ELSE
    SELECT res2;
    END IF;
    
END //

DELIMITER ;

CALL PrimeDivisor(5);

2

DELIMITER //

CREATE PROCEDURE numberPalindromeCheck(IN n INT, OUT stringResult VARCHAR(5))
BEGIN
    DECLARE num INT;
    DECLARE result INT;

    SET num = n;
    SET result = 0;

    WHILE num > 0 DO
        SET result = result*10 + (num % 10);
        SET num = num / 10;
    END WHILE;

    IF result = n THEN
        SELECT "YES" INTO stringResult;
    ELSE
        SELECT "NO" INTO stringResult;
    END IF;
END //


DELIMITER ;

CALL numberPalindromeCheck(141, @result);
SELECT @result;

0 replies

Shubhi27 · 2022-03-16T17:22:28Z

Shubhi27
Mar 16, 2022

**1**
DELIMITER $$
CREATE PROCEDURE checkPrime(IN n INT) BEGIN
DECLARE i, flag INT;
DECLARE str VARCHAR(255);
SET str = '1,';
SET i = 2,
    flag = 1;
while i < n do
SET flag =flag*i;
 if(n %i = 0) then
SET flag =0;
SET str= CONCAT(str,i,',');
END IF;
SET i = i + 1;
END WHILE;
if (flag >1) THEN
SELECT flag*n as factorial;
else
SELECT str as divisors;
END IF;
END $$
DELIMITER ;

**2**
DELIMITER  $$
CREATE PROCEDURE isPalindrome(IN n INT, INOUT result VARCHAR(10)) BEGIN
DECLARE x,  r, t INT;
SET x = n;
SET t = 0;
while x > 0 do
SET r = x %10;
SET t =(t * 10) + r;
SET x = x div 10;
end while;
IF (t = n) THEN
SET result = 'YES';
ELSE
SET result = 'NO';
END IF;
END  $$
DELIMITER;
call isPalindrome(1221, @res);
select @result;

0 replies

preeti-max · 2022-03-16T18:31:10Z

preeti-max
Mar 16, 2022

DELIMITER &
CREATE PROCEDURE isPrime(IN x INT,
    OUT outputIs INT
)
BEGIN
    SET outputIs = 1;
    IF x < 2 THEN
        SET outputIs = 0;
    ELSE
        SET @i = x - 1;
        WHILE @i >= 2
        DO
            IF(x mod @i = 0) THEN
                SET outputIs = 0;
            END IF;
        SET @i = @i - 1;
        END WHILE;
    END IF;
END &
DELIMITER ;


DELIMITER &
CREATE PROCEDURE FACTORIALS(IN N INT,OUT FACT INT)
BEGIN
DECLARE I INT DEFAULT 1;
SET FACT=1;
IF N<=1 THEN SET FACT=1;
ELSE
WHILE I<=N DO


SET FACT=FACT*I;
SET I=I+1;
END WHILE;
END IF;
SELECT @FACT;
END &
DELIMITER ;


DELIMITER &
CREATE PROCEDURE DIVISORS(IN N INT,OUT S VARCHAR(20))
BEGIN
DECLARE I INT DEFAULT 1;
SET S="";
WHILE I<=N DO
    IF N MOD I=0 THEN SET S=CONCAT(S,I,",");
    END IF;
    SET I=I+1;
END WHILE;
SELECT @S;
END &

DELIMITER ;



DELIMITER &
CREATE PROCEDURE OPERATION(IN  NUM INT)
BEGIN
CALL IsPrime(NUM,@prime);
IF @prime=1 THEN CALL FACTORIALS(NUM,@fact);
ELSE CALL DIVISORS(NUM,@div);
END IF;
END &
DELIMITER ;
CALL OPERATION(5);
CALL OPERATION(4);


DELIMITER &
CREATE PROCEDURE ISPALINDROME(IN N INT)
BEGIN
DECLARE TEMP INT ;
DECLARE REV INT DEFAULT 0;
DECLARE ANS VARCHAR(5);

SET TEMP=N;

WHILE TEMP>0 DO

SET REV=(REV*10)+(TEMP%10);
SET TEMP=TEMP/10;
END WHILE;
IF REV=N THEN SET ANS='YES';
ELSE SET ANS='NO';
END IF;
SELECT ANS;
END &
DELIMITER ;
CALL ISPALINDROME(1221);

0 replies

RohitN09 · 2022-03-16T19:50:48Z

RohitN09
Mar 16, 2022

DELIMITER //

CREATE PROCEDURE factorial(
        IN n INT
)
BEGIN
        DECLARE st VARCHAR(250);
        DECLARE k INT;
        DECLARE fact INT;
        SET st = "1";
        SET k = 2;
        SET fact = 1;
        WHILE k<n DO 
                IF (n mod k = 0) THEN
                        SET fact=0;
                        SET st = concat(st,", ",k);
                ELSE
                        SET fact = fact*k;
                END IF;
                SET k = k + 1;
        END WHILE;
        SET fact= fact*n;
        SET st = concat(st,", ",k);

        IF fact=0 THEN
                SELECT st;
        ELSE
                SELECT fact;
        END IF;
END //

DELIMITER ;

call factorial(4);
call factorial(5);

DELIMITER //

CREATE PROCEDURE isPalin(
        IN n int
)
BEGIN
        declare k int;
        declare r int default 0;
        declare rev int default 0;
        declare ans varchar(5) default "";

        set k=n;

        while k>0 do
                set r = k mod 10;
                set k = k/10;
                set rev = rev*10 + r;
        end while;
        if rev=n then
                set ans="Yes";
        else
                set ans="No";
        end if;

        SELECT ans;
END //

DELIMITER ;

call isPalin(121);

call isPalin(234);

0 replies

shreiyarandive · 2022-03-17T04:30:22Z

shreiyarandive
Mar 17, 2022

DELIMITER //
CREATE PROCEDURE getFactorial(
        IN num INT,
	OUT str varchar(255),
	OUT fact int
)
BEGIN
	declare flag int;
	declare i int;
	set flag = 1;
	set i = 2;
	set str = "1";
	While i < num
	do
		if(num mod i = 0) then
			set flag = 0;
			set str = concat(str,", ",i);
		end if;
		Set i = i+1;
	End while;
	set fact =1;
	if(flag=1) then
		while(num > 0) do
			set fact = fact*num;
			set num = num-1;
		end while;
		select fact;
        else
                select str;
	end if; 	
END //
delimiter ;

call getFactorial(5,@str,@fact);

delimiter //
CREATE PROCEDURE checkPalindrome(
	IN num INT,
        OUT str varchar(255)       
)
BEGIN
	declare temp int;
	declare rev int;
	set rev = 0;
	set temp = num;
        while(temp > 0) do
		set rev = rev * 10 + (temp mod 10);
		set temp = temp/10;
	end while;
	if rev=num then
		set str ="YES";
	else
		set str = "NO";
	end if;
END //
delimiter ;

call checkPalindrome(141,@result);
select result;

0 replies

PavanArvapally · 2022-03-20T11:36:06Z

PavanArvapally
Mar 20, 2022

1. DELIMITER //

CREATE Procedure isPrime(IN num INT)
BEGIN
    DECLARE flag int;
    DECLARE i int;
    DECLARE divisors VARCHAR(20);
    DECLARE fact int;
    SET flag = 0;
    SET i = 2;
    SET divisors = "1";
    SET fact = 1;

    WHILE(i<num) DO
    IF num % i = 0 THEN
        SET flag = 1;
        SET divisors = CONCAT(divisors,", ",i);
    END IF;
    SET i = i+1;
    END WHILE;

    SET i =2;

    IF(flag = 0) THEN
        SELECT divisors;
    ELSE
        
        WHILE(i = num) DO
            SET fact = fact*i;
            SET i = i+1;
        END WHILE;

        SELECT fact;
    END IF;

END//

DELIMITER;
--DROP PROCEDURE `isPrime`;


CALL isPrime('5');

2.  DELIMITER //

CREATE Procedure palindrome(IN num int, OUT ans VARCHAR(4))
BEGIN 
    DECLARE temp INT;
    DECLARE reverse INT;
    DECLARE duplicate INT;

    SET temp = 0;
    SET reverse = 0;
    SET duplicate = num;
    
    WHILE (num > 0)
    DO
        SET temp = num % 10;
        SET reverse = (reverse*10)+temp;
        SET num = num/10;
    END WHILE;

    IF duplicate = reverse THEN
        SET ans = 'YES';
    ELSE
        SET ans = 'NO';
    END IF;

END//

DELIMITER;

CALL palindrome(415,@ans);

SELECT @ans;

0 replies

Amrit-Raj22 · 2022-03-21T01:38:16Z

Amrit-Raj22
Mar 21, 2022

1--

DELIMITER //

CREATE PROCEDURE Prime(IN n INT)
BEGIN

    DECLARE i INT;
    DECLARE resPrime INT;
    DECLARE res1 INT;
    DECLARE res2 VARCHAR(255);

    SET i = 2;
    SET resPrime = 1;

    WHILE i < n DO
        IF (n % i = 0) 
        THEN
        SET resPrime = 0;
        END IF;
        SET i = i+1;
    END WHILE;
    
    IF resPrime = 1 
    THEN
        SET res1=1;
        SET i = 1;
        WHILE i <= n 
        DO
            SET res1 = res1*i;
            SET i = i+1;
        END WHILE;
        
    
    ELSE 
        SET res2 = "";
        SET i = 1;
        WHILE i <= n 
        DO
            IF (n % i = 0) 
            THEN
            SET res2 = CONCAT(res2, i, ", ");
            END IF;
            SET i = i+1;
        END WHILE;
    END IF;

    IF resPrime = 1 THEN
    SELECT res1;
    ELSE
    SELECT res2;
    END IF;
    
END //

DELIMITER ;

CALL Prime(5);

2--

DELIMITER //

CREATE PROCEDURE isPalindrom(
        IN n int
)
BEGIN
        declare k int;
        declare rem int default 0;
        declare rev int default 0;
        declare ans varchar(5) default "";

        set k=n;

        while k>0 do
                set rem = k mod 10;
                set k = k/10;
                set rev = rev*10 + rem;
        end while;
        if rev=n then
                set ans="Yes";
        else
                set ans="No";
        end if;

        SELECT ans;
END //

DELIMITER ;

call isPalindrom(989);

0 replies

DivikaAgrawal · 2022-03-21T02:59:34Z

DivikaAgrawal
Mar 21, 2022

DELIMITER//
CREATE PROCEDURE getFactorial(IN num INT,OUT str varchar(255),OUT factorial INT)
BEGIN
DECLARE count INT;
DECLARE i INT;
SET count=1;
SET i=2;
SET str="1";

while i<num
DO
if(num mod 1=0) then
SET count=0;
SET str=concat(str,",",i);
end if;
SET i=i+1;
END while
SET factorial=1;
if(count=1)then
while(num>0)
DO
SET factorial=factorial*num;
SET num=num-1;
END while;
SELECT factorial;
else
SELECT str;
END if;
END//
DELIMETER;
call getFactorial(8,@str,@factorial);

DELIMITER//
CREATE PROCEDURE isPalindrome(IN num INT)
BEGIN
DECLARE Reversed INT;
DECLARE i INT;
DECLARE temp INT;
DECLARE ans VARCHAR(3);
SET temp = num;
SET Reversed = 0;
SET i = 0;
WHILE(temp > 0)
DO
SET Reversed = (Reversed * 10) + (temp % 10);
SET temp = temp/10;
END WHILE;
IF(num = Reversed) THEN
SET ans = "YES";
ELSE
SET ans = "No";
END IF;
END//
DELIMITER;
call isPalindrome(121);

0 replies

Mrafe · 2022-03-21T03:20:16Z

Mrafe
Mar 21, 2022


CREATE PROCEDURE prime(IN n INT) BEGIN
DECLARE i,flag INT;
DECLARE str VARCHAR(255);
set str = '1,';
SET i = 2,
    flag = 1;
while i < n do
SET flag =flag*i;
 if(n %i = 0) then
SET flag =0;
SET str= CONCAT(str,i,',');
END IF;
SET i = i + 1;
END WHILE;
if (flag >1) THEN
SELECT flag*n as factorial;
else
SELECT str as divisors;
END IF;
END //
DELIMITER;

DELIMITER / / CREATE PROCEDURE palindrome(IN n INT, INOUT res VARCHAR(10)) BEGIN
DECLARE x,
    r,
    t INT;
SET x = n;
SET t = 0;
while x > 0 do
SET r = x %10;
SET t =(t * 10) + r;
SET x = x div 10;
end while;
IF (t = n) THEN
SET res = 'YES';
ELSE
SET res = 'NO';
END IF;
END / / DELIMITER;
call palindrome(454, @res);
select @res;

0 replies

meghvi-raj · 2022-07-06T05:16:23Z

meghvi-raj
Jul 6, 2022

--Q1

DELIMITER //

CREATE PROCEDURE getFactOfPrime(
	IN number INT
)
BEGIN
    DECLARE x INT;
    DECLARE fact INT;
    DECLARE str VARCHAR(225);
    SET x = 1;
    SET fact = 1;
    SET str = "1, ";
    WHILE x<number-1 
    DO
        SET x = x+1;
        SET fact = fact*x;
        IF(number mod x = 0) 
        THEN
            SET fact = 0;
            SET str = CONCAT(str,x,", ");
        END IF;
    END WHILE;
    SET fact = fact*number;
    SET str = CONCAT(str,number);
    IF(fact=0)
    THEN
        SELECT str;
    ELSE
        SELECT fact;
    END IF;
END //

DELIMITER ;

CALL getFactOfPrime(5);

--Q2

DELIMITER //

CREATE PROCEDURE isPalindrome(
	IN number INT,
    OUT str VARCHAR(4)
)
BEGIN
    DECLARE digit INT;
    DECLARE reverse INT;
    DECLARE copy INT;
    SET copy = number;
    SET digit = 0;
    SET reverse = 0;
    WHILE(number>0)
    DO
        SET digit = number mod 10;
        SET reverse = reverse*10+digit;
        SET number = number/10;
    END WHILE;
    IF reverse = copy
    THEN
        SET str = "YES";
    ELSE 
        SET str = "NO";
    END IF;

END//

DELIMITER  ;

CALL isPalindrome(12321,@ans);

SELECT @ans;

0 replies

uzma23 · 2022-07-06T05:20:49Z

uzma23
Jul 6, 2022

--Q1 Prime
DELIMITER //
CREATE PROCEDURE prime(IN n INT) BEGIN
DECLARE i,flag INT;
DECLARE str VARCHAR(255);
set str = '1,';
SET i = 2,
    flag = 1;
while i <= n do
SET flag =flag*i;
 if(n %i = 0) then
SET flag =0;
SET str= CONCAT(str,i,',');
END IF;
SET i = i + 1;
END WHILE;
if (flag >1) THEN
SELECT flag*n as factorial;
else
SELECT str as divisors;
END IF;
END //
DELIMITER;

call prime(4);


--Q2 palindrome
DELIMITER //
 CREATE PROCEDURE palindrome(IN n INT, INOUT res VARCHAR(10)) BEGIN
DECLARE x,
    r,
    t INT;
SET x = n;
SET t = 0;
while x > 0 do
SET r = x %10;
SET t =(t * 10) + r;
SET x = x div 10;
end while;
IF (t = n) THEN
SET res = 'YES';
ELSE
SET res = 'NO';
END IF;
END // 

DELIMITER;
call palindrome(454, @res);
select @res;

0 replies

Coder-093 · 2022-07-06T05:43:31Z

Coder-093
Jul 6, 2022

--1.
DELIMITER //

CREATE PROCEDURE getFactOfPrime(
	IN number INT
)

BEGIN
    DECLARE x INT;
    DECLARE fact INT;
    DECLARE str VARCHAR(225);
    SET x = 1;
    SET fact = 1;
    SET str = "1, ";
    WHILE x<number-1 
    DO
        SET x = x+1;
        SET fact = fact*x;
        IF(number mod x = 0) 
        THEN
            SET fact = 0;
            SET str = CONCAT(str,x,", ");
        END IF;
    END WHILE;
    SET fact = fact*number;
    SET str = CONCAT(str,number);
    IF(fact=0)
    THEN
        SELECT str;
    ELSE
        SELECT fact;
    END IF;
END //

DELIMITER ;

CALL getFactOfPrime(7);

--2.

DELIMITER //
CREATE PROCEDURE palindrome(IN n INT, INOUT res VARCHAR(10)) BEGIN
DECLARE x,
    r,
    t INT;
SET x = n;
SET t = 0;
while x > 0 do
SET r = x %10;
SET t =(t * 10) + r;
SET x = x div 10;
end while;
IF (t = n) THEN
SET res = 'YES';
ELSE
SET res = 'NO';
END IF;
END // 

DELIMITER;
call palindrome(12321, @res);

select @res;

0 replies

Kuntapaliwal · 2022-07-06T05:57:02Z

Kuntapaliwal
Jul 6, 2022

--1.  Write a stored procedure that takes an INT as input and returns the factorial of the number, if the number is prime. Else, it returns a comma-separated string of the divisors of the number.
-- Example:

-- Input = 5, Output = 120
-- Input = 4, Output = "1, 2, 4, "

DELIMITER //

create PROCEDURE getFactorial(In number int)
BEGIN
declare x int;
declare y int;
DECLARE str VARCHAR(225);
SET x = 1;
SET y = 1;
SET str = "1, ";
WHILE x < number -1
DO
SET x = x + 1;
SET y = y * x;
IF(number mod x = 0) THEN
SET y = 0;
SET str = CONCAT(str, x, ", ");
END IF;END WHILE;SET y = y*number;SET str = CONCAT(str, number);IF(y = 0) THEN
SELECT str;
ELSE
SELECT y;
END IF;
END //

DELIMITER;
CALL getFactorial(5);
CALL getFactorial(8);





--2.  Write a stored procedure that takes an INT as input and returns "YES" if the number is pallindrome or "NO" if the number is not pallindrome.
-- Example:

-- Input = 141, Output = "YES"
-- Input = 123, Output = "NO"
DELIMITER //

drop PROCEDURE palindrome;

CREATE PROCEDURE palindrome(in number int,out isPalindrome varchar(100))
BEGIN
DECLARE digits INT;
DECLARE reverse INT;
DECLARE copy INT;
SET copy = number;
SET digits = 0;
SET reverse = 0;
WHILE(number > 0) 
DO
SET digits = number mod 10;
SET reverse = reverse * 10 + digits;
SET number = number / 10;
END WHILE;
IF reverse = copy THEN
SET isPalindrome = "Yes";
ELSE
SET isPalindrome = "No";
END IF;
END //

DELIMITER ;

call palindrome(1221,@isPalindrome);

SELECT @isPalindrome;

0 replies

anuj9604 · 2023-07-27T03:57:31Z

anuj9604
Jul 27, 2023

1. Write a stored procedure that takes an INT as input and returns the factorial of the number, if the number is prime. Else, it returns a comma-separated string of the divisors of the number.

Solution

delimiter $$	

create procedure factor_ial(in i int, out result varchar(255))
begin
declare factorial int;
declare n int;
declare factors varchar(225);
set factorial = i;
set n = i-1;
set factors = "1, ";
loopy: while n>1
do
if (i mod n = 0) then
	set factorial = 0;
	set factors = concat(factors, n, ", ");
end if;
set factorial = factorial*n;
set n = n-1;
end while loopy;
if factors <> "1, " then
	set result = factors;
else
	set result = convert(factorial, char);
end if;
end $$

delimiter ;

call factor_ial(3, @result);

select @result;

2. Write a stored procedure that takes an INT as input and returns "YES" if the number is pallindrome or "NO" if the number is not pallindrome.

Solution

delimiter $$	

create procedure is_palindrome(in i int, out result varchar(10))
begin
declare inp varchar(255);
declare rev varchar(255);
set inp = convert(i, char);
set rev = reverse(inp);
if (inp=rev) then
	set result="YES";
else
	set result="No";
end if;
end $$

delimiter ;

call is_palindrome(111, @result);

select@result;

0 replies

niktwister · 2023-07-27T06:11:10Z

niktwister
Jul 27, 2023

1.Write a stored procedure that takes an INT as input and returns the factorial of the number, if the number is prime. Else, it returns a comma-separated string of the divisors of the number.
Example:

Input = 5, Output = 120
Input = 4, Output = "1, 2, 4, "

-- ------------- helper function to calculate factorial ------------- --

DELIMITER $$

CREATE FUNCTION IF NOT EXISTS factorial(num BIGINT)
RETURNS BIGINT
DETERMINISTIC
BEGIN
    DECLARE counter INT DEFAULT num;
    DECLARE fact BIGINT DEFAULT 1;
    
    IF num > 1 THEN
        WHILE counter > 0 DO
            SET fact = fact * counter;
            SET counter = counter - 1;
        END WHILE;
    END IF;
    
    RETURN fact;
END $$

DELIMITER ;

-- ------------- helper function to check if prime ------------- --

DELIMITER $$

CREATE FUNCTION IF NOT EXISTS isPrime(num INT)
RETURNS BOOL
DETERMINISTIC
BEGIN
    DECLARE result BOOL DEFAULT TRUE;
    DECLARE upperBound INT DEFAULT FLOOR(SQRT(num));
    DECLARE counter INT DEFAULT 2;

    IF num = 1 THEN SET result = FALSE;
    ELSEIF num = 2 THEN SET result = TRUE;
    ELSEIF num > 2 THEN
        
        loop1: WHILE counter <= upperBound DO
            IF num MOD counter = 0 THEN 
                SET result = FALSE;
                LEAVE loop1;
            END IF;
            SET counter = counter + 1;
        END WHILE loop1;
        
    END IF;

    RETURN result;

END $$

DELIMITER ;

-- ------------------------  required procedure ------------------------ --

DELIMITER $$

CREATE PROCEDURE IF NOT EXISTS getFactorialOrDivisors(IN num BIGINT, OUT output VARCHAR(200))
BEGIN
    DECLARE counter INT DEFAULT 1;

    IF isPrime(num) THEN
        SET output = factorial(num);
    ELSE
        SET output = "";
        
        WHILE counter <= num DO
            IF num MOD counter = 0 THEN
                SET output = CONCAT(output , counter , ", ");
            END IF;
            SET counter = counter + 1;
        END WHILE; 

    END IF;

END $$

DELIMITER ;

2.Write a stored procedure that takes an INT as input and returns "YES" if the number is pallindrome or "NO" if the number is not pallindrome.
Example:

Input = 141, Output = "YES"
Input = 123, Output = "NO"

DELIMITER $$

CREATE PROCEDURE IF NOT EXISTS isPalindrome(IN num INT, OUT output VARCHAR(3))
BEGIN

    DECLARE digitcount INT DEFAULT FLOOR(LOG10(num)) + 1;
    DECLARE reversed INT DEFAULT 0;
    DECLARE counter INT DEFAULT 0;
    
    IF digitcount = 1 THEN 
        SET reversed=num;
    ELSE
        WHILE counter <= digitcount - 1 DO
            SET reversed = reversed + ( FLOOR(num / POW(10,(digitcount - 1 - counter))) MOD 10 )*POW(10,counter);
            SET counter = counter + 1;
        END WHILE;
    END IF;
    
    IF num = reversed THEN
        SET output = 'YES';
    ELSE
        SET output = 'NO';
    END IF;

END $$

DELIMITER ;

0 replies

apoorva-sin · 2023-07-27T06:18:27Z

apoorva-sin
Jul 27, 2023

-- Discussion Forum 11 Part 1

delimiter $$

create function factorial (
	n int
)
returns int
deterministic 

begin
	
	declare ans int default 1;
	loop_label : loop
		if n = 1 then 
			leave loop_label;
		end if;
		set ans = ans * n;
		set n = n-1;
	end loop;

	return ans;
	
end $$

delimiter ;


drop procedure factors;
delimiter $$

create procedure factors(
	in n int,
	out ans varchar(100)
)

begin
	declare i int default 2;
	declare factors varchar(100) default '1, ';
	declare prime varchar(10) default 'true';
	
	loop_label: loop
		
		if i > ((n/2) + 1) then 
			leave loop_label;
		end if;
		if mod(n, i) = 0 then 
			set prime = 'false';
			select concat(factors, i, ', ') into factors;
		end if;
		
		set i = i+1;
	end loop;

	if prime = 'true' then 
		 set ans = factorial(n); 

	else 
		set factors = concat(factors, n);
		select factors into ans;
	end if;
end $$

delimiter ;

call factors(5, @ans);
select @ans;

-- Discussion Forum 11 Part 2

drop function isPalindrome;

delimiter $$

create function isPalindrome(
	n int
)
returns varchar(50)
deterministic

begin
	declare ans varchar(50) default '';
	declare backup int default n;

	loop_label: loop
		if (n = 0) then 
			leave loop_label;
		end if;
		set ans = (ans*10) + mod(n, 10);
		set n = n / 10;
	end loop;

	if ans = backup then
		return 'YES';
	else 
		return 'NO';
	end if;	
	
end $$

delimiter ;

select isPalindrome(1001);

0 replies

ashumore1998 · 2023-07-27T06:23:26Z

ashumore1998
Jul 27, 2023

/* 1 Write a stored procedure that takes an INT as input and returns the factorial of the number, if the number is prime. Else, it returns a comma-separated string of the divisors of the number.
Example:

Input = 5, Output = 120
Input = 4, Output = "1, 2, 4, "
*/

DELIMITER //
create procedure num_fact(in num int,out result varchar(500))
begin
DECLARE i INT default 2;
DECLARE divisorStr VARCHAR(1000) default '';
DECLARE factorial INT default 1;

IF num>1 then
  SET divisorStr = '1, ';
  while i <=floor(sqrt(num)) do
	if (num % i=0) THEN 
		SET divisorStr = CONCAT(divisorStr,i,' ,');
		if (i!= num/i) then 
			SET divisorStr = CONCAT(divisorStr,cast((num/i) as UNSIGNED),' ,');
		END IF;
	END IF;
	set i=i+1;
  END WHILE;
END IF;

IF divisorStr = '1, ' THEN
	SET i = 2;
	WHILE i<=num do
		SET factorial = factorial*i;
		SET i = i+1;
	END WHILE;
	SET result = CAST(factorial as CHAR);
ELSE
	SET result = divisorStr;
	
END IF;

END;
//
DELIMITER ;

CALL num_fact(7, @fact_op);
SELECT @fact_op as Result;

/* Write a stored procedure that takes an INT as input and returns "YES" if the number is pallindrome or "NO" if the number is not pallindrome.
Example:

Input = 141, Output = "YES"
Input = 123, Output = "NO"
*/

DELIMITER //
create procedure num_palindrome(in num int,out result varchar(10))
begin
declare pal varchar(100) default '';
declare pal2 varchar(100) default '';
set pal = cast(num as char);
set pal2 = reverse(pal);
IF pal = pal2
then set result= 'YES';
else
set result = 'NO';
end if;
end //

delimiter ;

call num_palindrome(2332,@pal_out);
select @pal_out as Results;

0 replies

prathameshyadure · 2023-07-27T06:25:26Z

prathameshyadure
Jul 27, 2023

-- Q1
-- Write a stored procedure that takes an INT as input and returns the factorial of the number,
-- if the number is prime. Else, it returns a comma-separated string of the divisors of the number.

/* creating stored function to check whether a number is Prime*/
delimiter $$
create function prm(num int)
returns bool
deterministic
begin
if num<=1 then
return false;
elseif num <=3 then
return true;
else
set @i=2;
while @i * @i <num do
if num % @i = 0 then
return false;
end if;
set @i = @i+1;
end while;
end if;
return true;
end$$
delimiter ;

drop function fact;

/* creating a function to calculate factorial of a number */
-- cnt should be BIGINT to handle prime numbers greater than
delimiter $$
create function fact(num int)
returns int
DETERMINISTIC
begin
declare cnt bigint default 1;

while num>0 do
	set cnt = cnt*num;
	set num = num-1;
END while;
return cnt;

end $$
delimiter ;

/* stored procedure */
drop procedure if exists if_prime_fact;
delimiter $$
create procedure if_prime_fact(IN num int)
begin
if prm(num)=1 then
select fact(num);
else
set @i=2;
set @op='1';
while @i <num do
if num % @i = 0 then
set @op = concat(@op,',',cast(@i as char));
end if;
set @i = @i+1;
end while;
select @op;
end if;

end$$
delimiter ;

/* Stored Procedure to Check if Number is Prime and Calculate its Factorial */
DROP PROCEDURE IF EXISTS if_prime_fact;
DELIMITER $$
CREATE PROCEDURE if_prime_fact(IN num INT)
BEGIN
DECLARE is_prime BOOL;
DECLARE cnt BIGINT DEFAULT 1;
DECLARE i INT;

-- Check if the number is prime
IF num <= 1 THEN
    SET is_prime = FALSE;
ELSEIF num <= 3 THEN
    SET is_prime = TRUE;
ELSE
    SET i = 2;
    SET is_prime = TRUE;

    WHILE i * i <= num DO
        IF num % i = 0 THEN
            SET is_prime = FALSE;
        END IF;
        SET i = i + 1;
    END WHILE;
END IF;

IF is_prime THEN
    -- If the number is prime, calculate its factorial
    SET i = num;
    WHILE i > 0 DO
        SET cnt = cnt * i;
        SET i = i - 1;
    END WHILE;

    SELECT cnt AS factorial;
ELSE
    -- If the number is not prime, find its prime factors
    SET i = 2;
    SET @op = '1';

    WHILE i < num DO
        IF num % i = 0 THEN
            SET @op = CONCAT(@op, ',', CAST(i AS CHAR));
        END IF;
        SET i = i + 1;
    END WHILE;

    SELECT @op AS prime_factors;
END IF;

END$$
DELIMITER ;

-- Q2
-- Write a stored procedure that takes an INT as input and returns "YES" if the number is pallindrome or "NO" if the number is not pallindrome.

drop procedure palindrome;
delimiter $$
create procedure palindrome(IN num INT)
begin

set @n = num;
set @r = 0;

while num > 0 do
    set @re = num % 10;
    set @r = @r * 10 + @re;
    set num = floor(num / 10);
end while;

if @n = @r then
    select 'Yes';
else
    select 'No';
end if;

end$$
delimiter ;

0 replies

ManasFuturense · 2023-07-27T06:26:40Z

ManasFuturense
Jul 27, 2023

-- 1. Write a stored procedure that takes an INT as input and returns the factorial of the number, if the number is prime. Else, it returns a comma-separated string of the divisors of the number.
-- Example:

-- Input = 5, Output = 120
-- Input = 4, Output = "1, 2, 4, "

DELIMITER $$
CREATE PROCEDURE getFactPrime(IN num INT, OUT result VARCHAR(50))
BEGIN
DECLARE i INT;
DECLARE is_prime BOOLEAN DEFAULT TRUE;
DECLARE divisor_list VARCHAR(255) DEFAULT '';
DECLARE factorial_result INT DEFAULT 1;

IF num < 2 THEN
    SET is_prime = FALSE;
ELSE
    SET i = 2;
    WHILE i * i <= num DO
        IF num % i = 0 THEN
            SET is_prime = FALSE;
            SET divisor_list = CONCAT(divisor_list, i, ',');
        END IF;
        SET i = i + 1;
    END WHILE;
    SET divisor_list = CONCAT(divisor_list, num);
END IF;

IF is_prime THEN
    SET i = 2;
    WHILE i <= num DO
        SET factorial_result = factorial_result * i;
        SET i = i + 1;
    END WHILE;
    SET result = CAST(factorial_result AS CHAR);
ELSE
    SET result = divisor_list;
END IF;

END $$
DELIMITER ;

CALL getFactPrime(4, @output);
SELECT @output;

-- 2. Write a stored procedure that takes an INT as input and returns "YES" if the number is pallindrome or "NO" if the number is not pallindrome.
-- Example:

-- Input = 141, Output = "YES"
-- Input = 123, Output = "NO"

DELIMITER $$
CREATE PROCEDURE palindrome(IN n INT, OUT result VARCHAR(20))
BEGIN
DECLARE temp INT;
DECLARE rev INT DEFAULT 0;
DECLARE rem INT;
SET temp = n;

WHILE temp > 0 DO
    SET rem = temp % 10;
    SET rev = rev * 10 + rem; -- Properly build the reversed number
    SET temp = temp DIV 10; -- Use DIV instead of /
END WHILE;

IF n = rev THEN
    SET result = 'Yes';
ELSE
    SET result = 'No';
END IF;

END $$
DELIMITER ;

CALL palindrome(111, @output);
SELECT @output;

0 replies

Shubham-Futurense · 2023-07-27T06:38:01Z

Shubham-Futurense
Jul 27, 2023

#1
DELIMITER $$
create procedure factorialOfPrime(IN inp INT )
BEGIN
DECLARE i INT;
DECLARE fact INT;
DECLARE divi VARCHAR(50);
DECLARE count INT;
SET count=0;
SET i=2;
SET fact=1;
SET divi="1";
WHILE i<=inp DO
SET fact=fact*i;
IF inp mod i=0
THEN
SET count=count+1;
SET divi=concat(divi,',',i);
END IF;
SET i=i+1;
END WHILE;
IF count>1
THEN
SELECT divi;
ELSE
SELECT fact;
END IF;

END
$$

DELIMITER ;

#2
DELIMITER $$
create procedure isPallindrome(IN inp INT )
BEGIN
DECLARE n INT;
DECLARE rev INT;
SET n=inp;
SET rev=0;

WHILE n>0 DO
	SET rev=rev*10 + n mod 10;
    SET n=n/10;
    
END WHILE;
IF rev=inp
	THEN 
    SELECT ‘YES’;
ELSE
    SELECT ‘NO’;
END IF;

END
$$

DELIMITER ;

0 replies

dhanyaMeruva9 · 2023-07-27T08:47:44Z

dhanyaMeruva9
Jul 27, 2023

--1
delimiter $$
CREATE PROCEDURE getFactOfPrime(
IN number INT
)
BEGIN
DECLARE x INT;
DECLARE fact INT;
DECLARE str VARCHAR(225);
SET x = 1;
SET fact = 1;
SET str = "1, ";
WHILE x<number-1
DO
SET x = x+1;
SET fact = factx;
IF(number mod x = 0)
THEN
SET fact = 0;
SET str = CONCAT(str,x,", ");
END IF;
END WHILE;
SET fact = factnumber;
SET str = CONCAT(str,number);
IF(fact=0)
THEN
SELECT str;
ELSE
SELECT fact;
END IF;
END $$
delimiter ;

CALL getFactOfPrime(5);

--2
DELIMITER //

CREATE PROCEDURE isPalindrome(
IN number INT,
OUT str VARCHAR(4)
)
BEGIN
DECLARE digit INT;
DECLARE reverse INT;
DECLARE copy INT;
SET copy = number;
SET digit = 0;
SET reverse = 0;
WHILE(number>0)
DO
SET digit = number mod 10;
SET reverse = reverse*10+digit;
SET number = number/10;
END WHILE;
IF reverse = copy
THEN
SET str = "YES";
ELSE
SET str = "NO";
END IF;

END//

DELIMITER ;

CALL isPalindrome(12321,@Ans);
SELECT @Ans;

0 replies

var5 · 2023-07-27T19:03:50Z

var5
Jul 27, 2023

Write a stored procedure that takes an INT as input and returns the factorial of the
number, if the number is prime. Else, it returns a comma-separated string of the divisors
of the number.
 Example:
o Input = 5, Output = 120
o Input = 4, Output = "1, 2, 4, "

DELIMITER {{
CREATE PROCEDURE calFactOrDiv(IN inputNum INT, OUT result VARCHAR(255))
BEGIN
DECLARE i INT;
DECLARE isPrime INT;
DECLARE divisorList VARCHAR(255);
DECLARE factorial INT;
SET i = 2;
SET isPrime = 1;
SET divisorList = '';
SET factorial = 1;
REPEAT
IF inputNum % i = 0 THEN
SET isPrime = 0;
SET divisorList = CONCAT(divisorList, i, ', ');
END IF;
SET i = i + 1;
UNTIL i > inputNum / 2 END REPEAT;
IF isPrime = 1 THEN
SET i = 1;
REPEAT
SET factorial = factorial * i;
SET i = i + 1;
UNTIL i > inputNum END REPEAT;
SET result = CAST(factorial AS CHAR);
ELSE
SET result = divisorList;
END IF;
END }}
DELIMITER ;
CALL calFactOrDiv(12, @res);
select @res;

Write a stored procedure that takes an INT as input and returns "YES" if the number is
pallindrome or "NO" if the number is not pallindrome.
 Example:
o Input = 141, Output = "YES"
o Input = 123, Output = "NO"

DELIMITER ₹₹
CREATE PROCEDURE palindrome(IN inputNum INT, OUT result VARCHAR(3))
BEGIN
DECLARE reversedNum INT;
DECLARE originalNum INT;
SET originalNum = inputNum;
SET reversedNum = 0;
REPEAT
SET reversedNum = reversedNum * 10 + originalNum % 10;
SET originalNum = originalNum DIV 10;
UNTIL originalNum = 0 END REPEAT;
IF inputNum = reversedNum THEN
SET result = 'YES';
ELSE
SET result = 'NO';
END IF;
END ₹₹
DELIMITER ;
SET @inputNumber = 141;
CALL palindrome(@inputNumber, @outputResult);
SELECT @outputResult;

0 replies

Koustav-Sarkar · 2023-07-28T05:47:41Z

Koustav-Sarkar
Jul 28, 2023

-- 1 Write a stored procedure that takes an INT as input and returns the factorial of the number, if the number is prime. Else, it returns a comma-separated string of the divisors of the number.
-- Example:
-- Input = 5, Output = 120
-- Input = 4, Output = "1, 2, 4, "
DELIMITER //
CREATE PROCEDURE getFactOfPrime(
IN number INT
)
BEGIN
DECLARE x INT;
DECLARE fact INT DEFAULT 1;
DECLARE is_prime BOOLEAN DEFAULT TRUE;
DECLARE prime_factors VARCHAR(255) DEFAULT '';
set prime_factors = CONCAT(prime_factors, 1, ', ');

SET x = 2;
WHILE x <= FLOOR(SQRT(number))
DO
    IF number MOD x = 0 THEN
        SET is_prime = FALSE;
        SET fact = fact * x;
        SET prime_factors = CONCAT(prime_factors, x, ', ');
    END IF;
    SET x = x + 1;
END WHILE;

IF is_prime THEN
SET fact = fact * number;
  select fact as Output;
ELSE
    
    SET prime_factors = CONCAT(prime_factors, number);
    SELECT prime_factors as Output;
END IF;

-- SELECT fact AS factorial, prime_factors AS primeFactors;
END //

DELIMITER ;
CALL getFactOfPrime(6);

-- 2 Write a stored procedure that takes an INT as input and returns "YES" if the number is pallindrome or "NO" if the number is not pallindrome.
-- Example:

-- Input = 141, Output = "YES"
-- Input = 123, Output = "NO"
DELIMITER //
create procedure checkPalin(in num int, out ans char(20) )
begin
declare rev int;
set rev = CAST(REVERSE(CAST(num AS CHAR)) AS SIGNED);
if rev=num then set ans="Yes";
else
set ans="No";
end if;
end //
DELIMITER ;
call checkPalin(241,@Ans);
select @Ans as CheckPalindrome;

0 replies

NANDU-R-N · 2023-07-31T08:29:20Z

NANDU-R-N
Jul 31, 2023

Write a stored procedure that takes an INT as input and returns the factorial of the number, if the number is prime. Else, it returns a comma-separated string of the divisors of the number.
-- Example:

-- Input = 5, Output = 120
-- Input = 4, Output = "1, 2, 4, "

CREATE Procedure Fact(IN num INT)
BEGIN
DECLARE flag int;
DECLARE i int;
DECLARE divisors VARCHAR(20);
DECLARE fact int;
SET flag = 0;
SET i = 2;
SET divisors = "1";
SET fact = 1;

WHILE(i<num) DO
IF num % i = 0 THEN
    SET flag = 1;
    SET divisors = CONCAT(divisors,", ",i);
END IF;
SET i = i+1;
END WHILE;

SET i =2;

IF(flag = 0) THEN
    SELECT divisors;
ELSE
    
    WHILE(i = num) DO
        SET fact = fact*i;
        SET i = i+1;
    END WHILE;

    SELECT fact;
END IF;

END//

DELIMITER;
--DROP PROCEDURE isPrime;

CALL Fact('7');

Write a stored procedure that takes an INT as input and returns "YES" if the number is pallindrome or "NO" if the number is not pallindrome.
Example:

Input = 141, Output = "YES"
Input = 123, Output = "NO"

CREATE PROCEDURE palindrome(in number int,out isPalindrome varchar(100))
BEGIN
DECLARE digits INT;
DECLARE reverse INT;
DECLARE copy INT;
SET copy = number;
SET digits = 0;
SET reverse = 0;
WHILE(number > 0)
DO
SET digits = number mod 10;
SET reverse = reverse * 10 + digits;
SET number = number / 10;
END WHILE;
IF reverse = copy THEN
SET isPalindrome = "Yes";
ELSE
SET isPalindrome = "No";
END IF;
END $$

DELIMITER ;

call palindrome(14322341,@isPalindrome);

0 replies

Tasks - Conditions and Loops #11

Uh oh!

akash-coded Mar 16, 2022 Maintainer

Conditional and Looping Statements in MySQL

Replies: 34 comments

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Conditional and Looping Statements in MySQL

Uh oh!

1

2

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

1. Write a stored procedure that takes an INT as input and returns the factorial of the number, if the number is prime. Else, it returns a comma-separated string of the divisors of the number.

2. Write a stored procedure that takes an INT as input and returns "YES" if the number is pallindrome or "NO" if the number is not pallindrome.

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

akash-coded
Mar 16, 2022
Maintainer