MySQL SQL

MySQL Stored Procedures

Store a reusable sequence of SQL statements in the database.

DELIMITER //
CREATE PROCEDURE GetProducts()
BEGIN
  SELECT * FROM products;
END //
DELIMITER ;

CALL GetProducts();

Use parameters and controlled privileges for reusable database operations. Keep procedure definitions in migrations.