What is a routine and how is it created

1.	What is a routine and how is it created
Answer» A stored ROUTINE is either a PROCEDURE or a function. Stored ROUTINES are created with the CREATE PROCEDURE and CREATE FUNCTION statements DELIMITER // CREATE PROCEDURE GetAllProducts() BEGIN SELECT * FROM PRODUCTS; END // DELIMITER ;

Discussion