Home
SQL / MySQL
Aggregate Functions
Backup Load
Command MySQL
Cursor
Data Type
Database
Date Time
Engine
Event
Flow Control
FullText Search
Function
Geometric
I18N
Insert Delete Update
Join
Key
Math
Procedure Function
Regular Expression
Select Clause
String
Table Index
Transaction
Trigger
User Permission
View
Where Clause
XML
Function « Procedure Function « SQL / MySQL
SQL / MySQL
Procedure Function
Function
1.
Creating Functions
2.
A function that takes a parameter, performs an operation using an SQL function, and returns the result
3.
Single statement function
4.
Nested function call
5.
Using buildin function in user-defined function
6.
To remove a stored function, use the DROP command
7.
Create a procedure for 'READS SQL DATA'
8.
Math calculation in a function
9.
Function to shorten a string
10.
Calculate number of day