Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Begin End Mysql statement

Example of Begin End Mysql statement:

CREATE PROCEDURE example_procedure (IN parameter1 INT)
BEGIN DECLARE variable1 INT;
SET variable1 = parameter1 + 1;
IF variable1 = 0 THEN INSERT INTO t VALUES (17);
END IF;
IF parameter1 = 0 THEN UPDATE t SET s1 = s1 + 1;
ELSE UPDATE t SET s1 = s1 + 2;
END IF;

Example of Mysql Begin End

[begin_label:] BEGIN
[statement_list]
END [end_label]