Skip to main content

CREATE PROCEDURE & CALL

Learn CREATE PROCEDURE & CALL (Stored Procedures, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction A stored procedure is a named block of SQL kept inside the server. You create it once with CREATE PROCEDURE and run it with CALL . Because the body contains semicolons, client tools need DELIMITER to change the statement terminator while defining it.

More lessons in Stored Procedures