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.