Please enable JavaScript.
Coggle requires JavaScript to display documents.
BASIC-SQL-PROCEDURES - Coggle Diagram
BASIC-SQL-PROCEDURES
FUNCTIONS
Return
Single
Value
Attributes
DETERMINISTIC
READS SQL DATA
MODIFIES SQL DATA
Create
Function f_name(...)
Returns Integer
Attributes
Begin ...
Return val
END
Used
SQL
Statements
DROP
Function
If Exists
f_name
WHAT
Database
Object
Called
External
App
Fast
Data
Security
CREATE
DELIMITER $$
Create Procedure
get_clients()
Begin
Select ...;
Select ...;
End$$
DELIMITER ;
CALL
get_clients()
PARAMS
Create
Procedure
get_clients()
state Char(2)
Default
Value
Required
Null
BEGIN
If param IS Null
Then
Set param = defaultValue
End If;
Return
All
By-Default
Validation
Error-Codes
Search
SqlState-Errors
BEGIN
If condition
Then
Signal Sqlstate errorCode
Set Message_Text = 'message'
End If
Update ...
Output
Create Procedure
prod_name()
x INT
OUT y INT
OUT z INT
BEGIN
Select v1, v2
INTO y, z
From ...
END
DROP
Procedure
If Exists
get_clients
VARIABLES
User-Defined
Set
'@var
= val
Avoid
Session
Local
Inside
Procedure
Function
DECLARE
var
INT
[Default 0]
SET
var = val
Select ...
INTO var
From ...
CONVENTIONS
Prefixing
fn_
proc_
Delimiter
$$
//