DBMS 6OR

Area of Circle
Akash avatar
Akash
mysql
09/08/2022 4:27 AM
360 B
28
Indexable
CREATE TABLE Circle (radius INT, area FLOAT(10));

DELIMITER $
CREATE PROCEDURE FindArea(IN radius INT)
 BEGIN 
   INSERT INTO Circle VALUES (radius, 3.14*radius*radius);
 END $

DELIMITER ;

CALL FindArea(10);
CALL FindArea(7);
CALL FindArea(5);

SELECT * FROM Circle;
Editor is loading...