Stored Procedures
CREATE PROCEDURE, EK, NAYA, stored, procedure, banaта hai — parameters, accept, kar, sakta hai, aur, MULTIPLE, SQL, statements, EK, saath, EXECUTE, kar, sakta hai. CALL, statement, se, procedure, INVOKE, kiya, jaata hai.
Stored, procedures, database, PAR, EXECUTE, HOTE, HAIN, isliye, NETWORK, round-trips, kam, hote, HAIN, jab, MULTIPLE, statements, EK, saath, RUN, karne, ki, ZAROORAT, hoti, hai.
DELIMITER //
CREATE PROCEDURE GetUserOrders(IN userId INT)
BEGIN
SELECT * FROM orders WHERE user_id = userId;
END //
DELIMITER ;
CALL GetUserOrders(42);- CREATE PROCEDURE = reusable, SQL, logic, banaता, hai
- CALL, se, procedure, invoke, kiya, jaata, hai
- Network, round-trips, kam, karta, hai, multiple, statements, ke, liye
IN, parameters, (default) procedure, ke, ANDAR, values, PASS, karte, hain. OUT, parameters, se, procedure, values, CALLER, ko, WAAPAS, RETURN, kar, sakta hai. INOUT, DONO, directions, mein, kaam, karta hai.
DELIMITER //
CREATE PROCEDURE GetOrderCount(IN userId INT, OUT total INT)
BEGIN
SELECT COUNT(*) INTO total FROM orders WHERE user_id = userId;
END //
DELIMITER ;
CALL GetOrderCount(42, @count);
SELECT @count;DECLARE ... HANDLER, se, stored, procedures, ke, ANDAR, errors, HANDLE, kiye, ja, sakte, HAIN — jaise, EK, SQLEXCEPTION, HANDLER, jo, error, hone, PAR, EK, ROLLBACK, karta hai.