MySQL > Create Function > Call MySQL Function > Execution MySQL Function > MysQL Show Listed Functions

Use of MySQL function will make our coding easier. Function can contain some business logic.

So I will create MySQL function first using below query:

DELIMITER // DROP FUNCTION IF EXISTS MyFunction; CREATE FUNCTION MyFunction(p1 INT) RETURNS VARCHAR(50) BEGIN DECLARE v1 VARCHAR(50) DEFAULT ""; SELECT concat(name,'-',roll) INTO v1 FROM table1 WHERE id = p1; RETURN v1; END; //

So our MySQL function created, now we will list our available MySQL functions using below query:

SHOW FUNCTION STATUS

Now we will select/execute MySQL function using below query

select *,MyFunction(id) as 'function' from table1;

Which will results like below screenshot: