Use DEFAULT Statement in Procedure

The Tutorial illustrate an example 'Use DEFAULT Statement in Procedure'. To understand 'Default Statement in Procedure', we create a procedure 'abc'. The BEGIN statement  indicate the beginning of an SQL declare section. The Declare is used to define a variable 'x', 'y' and 'z ', whose data type is integer type. The variable x and y set to a default value of '15'.The  variable 'z' assigned the sum  value of variable 'x' and 'y'. An SQL declare variable end with an END statement.

select z  : The select z returns you the sum value of variable 'x' and 'y' into 'z'.

Create Procedure

delimiter $$

create procedure abc()
BEGIN 
	DECLARE x int DEFAULT 15;
	DECLARE y int DEFAULT 15;
	DECLARE z int;

	set z = x+y;
	select z;

END$$
delimiter ;

Call Procedure

To invoke a procedure 'abc', we use call abc ( ) given below:

Result

+------+
| z    |
+------+
| 30   |
+------+

Related Tags for Use DEFAULT Statement in Procedure:
c,  default,  tutorial,  state,  ria,  create,  example,  statement,  to,  exam,  proc,  e,  il,  procedure,  use,  ul,  ce,  fault,  in,  sta,  m,  nt,  tr,  em,  abc,  me,  pro,  rate,  tor,  xa,  xamp,  s,  at,  ll,  mpl,  ea,  du,  and,  stat,  str,  tutor,  s,  s,  roc,  ri,  th,  bc,  st,  ab,  efault,  ple,  pl,  pr,  nd,  o

More Tutorials from this section

• SQL Example, Codes and Tutorials
• Aggregate Functions
• Backup File With Separator
• Backup Into txt File
• Backup selected records into txt file
• Call Procedure
• Close Cursors in SQL
• Create After Insert Trigger in SQL
• Create Before Insert Trigger in SQL
• Create Before Update Trigger in SQL
• Create Delete Trigger in SQL
• Create a Simple Procedure
• Create After Update Trigger in SQL
• Create a database
• Creating Cursors in SQL
• The Normal Forms
• Database Normalization
• Second Normal Form (2NF)
• Third Normal Form (1NF)
• Data Normalization

Ask Questions?    Discuss: Use DEFAULT Statement in Procedure  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):