create database japan4;

use japan4

create table abc (
aaa varchar(10),
bbb int(4)
);

INSERT INTO abc VALUES ('aaa', 100);
INSERT INTO abc VALUES ('bbb', 200);

delimiter //

create procedure kimsh (IN num int)
BEGIN
IF num > 0 THEN
UPDATE abc SET bbb = bbb - 50;
ELSE
UPDATE abc SET bbb = bbb + 100;
END IF;
END
//

delimiter ;

call kimsh(1);

SELECT * FROM abc;

call kimsh(-1);

SELECT * FROM abc;

##################################

create table person (
name varchar(20),
age int(4)
);

delimiter //

create procedure kim (IN a varchar(20), IN b int, OUT c varchar(30))
BEGIN
INSERT INTO person values (a, b);
SELECT CONCAT('Hello', a);
END
//

delimiter ;

call kim ('kimsh', 20, @kk);