MySQL Functions

Creating a function

In MySQL, Function can also be created. A function always returns a value using the return statement. The function can be used in SQL queries.

Syntax

Parameter:

Function_name: name of the function

Parameter: number of parameter. It can be one or more than one.

return_datatype: return value datatype of the function

declaration_section: all variables are declared.

executable_section: code for the function is written here.

Example 1

Step 1: Create database and table.

Database: employee

Table 1 : designation

Table 2 : staff

Step 2: Create a function

Function query:

Step 3: Execute the function

Query :

SELECT id, get_designation1(`d_id`) as DESIGNATION, name FROM 'staff'

Drop a function

In MySQL Function can also be dropped. When A function id dropped, it is removed from the database.

Syntax:

Parameter

function_name: name of the function to be dropped.

Example 1:

drop function get_designation_name;