DBMS 6OR

Area of Circle
avatar
Akash
mysql
2 years ago
269 B
2
Indexable
Never
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;