Learn SQL Database Programming

Syntax for stored procedures

To create a stored procedure, you can use the following sample syntax:

DELIMITER $$CREATE PROCEDURE storedprocname() BEGIN your sql statments go here;  END $$DELIMITER ;

To call the stored procedure that you just created, you can use the following sample syntax:

CALL storedprocname ();

To use IN parameters in a stored procedure, you can use the following sample syntax:

DELIMITER $$CREATE PROCEDURE storedprocname(IN in_varname vartype, IN in_varname2 vartype) BEGIN SELECT * FROM tablename  WHERE col1 = in_varname AND col2 = in_varname2 END $$DELIMITER ;

To call your stored procedure with IN parameters, you can use the following sample syntax:

CALL storedprocname('value', value);

To use IN parameters in a stored ...