How to add a select statement to a function of which will display the results?

[Raisen]

Hello,

Is it possible to create a function that uses a select statement and displays the results.

Any and all help would be greatly appreciated.

My table:

CREATE TABLE COLOURS
       (C_ID VARCHAR2 (4) NOT NULL,
        HC VARCHAR2 (4),
        AC VARCHAR2 (4),
        TOTAL NUMBER (2),
        SCORES NUMBER (2));
 
 
INSERT INTO COLOURS VALUES
('C1', 'RED', 'BLUE',8,'');
 
INSERT INTO COLOURS VALUES
('C2', 'RED', 'BLUE', 9,'');
 
INSERT INTO COLOURS VALUES
('C3','BLUE', 'RED', 10,'');
 
INSERT INTO COLOURS VALUES
('C4','BLUE', 'RED', 11,'');
 
 

And my select statement:

SELECT   HC, C_ID, TOTAL, TOTAL(HC) as TOTALSCORES
FROM  COLOURS
ORDER BY totalscores DESC;
 

Thanks again.

[Rabbit]

You mean a stored procedure? Functions don't return result sets.

[Raisen]

Yup sorry thats the one.

[Rabbit]

The basic syntax to create a procedure is:

CREATE PROCEDURE procedurename ()
BEGIN
   SELECT COUNT(*) INTO param1 FROM t;
END

More can be found on the MySQL documentation. https://dev.mysql.com/doc/refman/5.0...procedure.html