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;
