Stored Procedures in MySQL

What is a Stored Procedure?

Create and Call

DELIMITER //
CREATE PROCEDURE add_student(IN p_name VARCHAR(50), IN p_marks INT)
BEGIN
    INSERT INTO students(name, marks) VALUES(p_name, p_marks);
END //
DELIMITER ;

CALL add_student('Aman', 88);

Why Use Them?

• Reuse complex logic by name.
• Reduce network traffic (one CALL vs many queries).
• Centralise business rules in the database.

Summary

• A stored procedure is saved SQL run with CALL.
• Use IN parameters to pass values; great for reusable logic.

Stored Procedure क्या है?

Create और Call

DELIMITER //
CREATE PROCEDURE add_student(IN p_name VARCHAR(50), IN p_marks INT)
BEGIN
    INSERT INTO students(name, marks) VALUES(p_name, p_marks);
END //
DELIMITER ;

CALL add_student('Aman', 88);

क्यों Use करें?

• जटिल logic नाम से reuse करें।
• Network traffic घटाएं (एक CALL बनाम कई queries)।
• Business rules database में केंद्रित करें।

सारांश

• Stored procedure saved SQL है जो CALL से चलती है।
• Values pass करने के लिए IN parameters; reusable logic के लिए बढ़िया।