ch26sp.sql

来自「說明JSP平台、開發環境」· SQL 代码 · 共 30 行

/* for MySQL test database */
/* 1st SP named sp_GetImg */
CREATE PROCEDURE sp_GetImg (IN i_pubid VARCHAR(4))
BEGIN
  SELECT logo
  FROM pub_info
  WHERE pub_id = i_pubid;
END

/* 2nd SP named sp_GetAuthor, sp_GetBook_Info */
/* CREATE PROCEDURE sp_GetAuthor (IN fname VARCHAR(10)) */
CREATE PROCEDURE sp_GetAuthor ()
BEGIN
  SELECT DISTINCT author
  FROM book
  ORDER BY author;
END

/* 3rd SP named sp_GetChat */
CREATE PROCEDURE sp_GetChat
(IN rec_no INT, OUT outmsg VARCHAR(50))
BEGIN
  SET SQL_SELECT_LIMIT = rec_no;
  SELECT *
  FROM newchat
  ORDER BY chattime DESC;
  SET SQL_SELECT_LIMIT = DEFAULT;

  SELECT 'Fetching records successfully!' into outmsg;
  /* SELECT 'ъ