User-Defined Functions
CREATE FUNCTION, EK, VALUE, RETURN, karti, hai (stored, procedures, ki, tarah, NAHI, JO, results, "return" nahi, karte) — SELECT, statements, mein, DIRECTLY, use, ki, ja, sakti, hai, EK, built-in, function, (jaise, UPPER()) ki, TARAH.
Functions, ek, specific, RETURN, type, DECLARE, karti, HAIN — deterministic, ya, non-deterministic, MARK, ki, ja, sakti, hain (jaise, NOW(), non-deterministic, hai, kyunki, HAR, call, PAR, DIFFERENT, VALUE, deta, hai).
DELIMITER //
CREATE FUNCTION CalculateDiscount(price DECIMAL(10,2), percent INT)
RETURNS DECIMAL(10,2)
DETERMINISTIC
BEGIN
RETURN price - (price * percent / 100);
END //
DELIMITER ;
SELECT name, CalculateDiscount(price, 10) AS discounted_price FROM products;- CREATE FUNCTION = ek value, return, karne, waali, custom, logic
- SELECT statements, mein, directly, use, ki, ja, sakti, hai
- DETERMINISTIC keyword = same inputs, se, hamesha, same, output
MySQL, mein, MANY, built-in, functions, HAIN (UPPER(), NOW(), CONCAT()) — user-defined, functions, sirf, TAB, banaो, jab, CUSTOM, logic, KISI, built-in, function, se, achieve, na, ho, sake.
SELECT UPPER(name), NOW(), CONCAT(first_name, ' ', last_name) FROM users;WHERE, clause, mein, EK, column, PAR, function, apply, karne, se, (jaise, WHERE UPPER(name) = 'AARAV') indexes, USE, hona, ROK, sakta hai — generated, columns, (MySQL 5.7+) ke, saath, EK, index, banaake, ISE, avoid, kiya, ja, sakta hai.