
CREATE PROCEDURE simpleproc1()
BEGIN
  SELECT AREA,PREF FROM REGION;
END

