Creating and Using Stored Procedures in MySQL

Published July 26, 2025 By Sai Sree Ram Gundepudi

Example

DELIMITER //
CREATE PROCEDURE GetHighSalary()
BEGIN
  SELECT * FROM employees WHERE salary > 100000;
END //
DELIMITER ;

CALL GetHighSalary();

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article