DELIMITER //
CREATE PROCEDURE ins_upd (in x int(10), in y varchar(20))
begin
if (x IN (SELECT ID FROM my_table) then
UPDATE my_table SET ID=x, NAME=y;
else
INSERT INTO my_table values (x, y);
end if;
end//