Page 134 - CITS - CSA - TP (Volume 1) - Hindi

कंप्यूटर सॉफ्टवेयर एप्लीकेशन- CITS

(‘Book 3 , ‘Author 3 , 3);

INSERT INTO users (name, email) VALUES
(‘User 1 , ‘user1@example.com ),

(‘User 2 , ‘user2@example.com );

4 ोड ोसीजर (STORED PROCEDURE) –
DELIMITER //

CREATE PROCEDURE GetBooksByAuthor(IN authorName VARCHAR(255))

BEGIN
SELECT * FROM books WHERE author = authorName;

END //

DELIMITER ;
िट गर –

DELIMITER //

CREATE TRIGGER AfterBookBorrowed

AFTER INSERT ON borrowed_books
FOR EACH ROW

BEGIN

UPDATE books

SET quantity = quantity - 1
WHERE book_id = NEW.book_id;

END //

DELIMITER ;
5 कस र (CURSOR)–

DELIMITER //

CREATE PROCEDURE DisplayBooksAndQuantities()
BEGIN

DECLARE done INT DEFAULT FALSE;

DECLARE book_title VARCHAR(255);

DECLARE book_quantity INT;
DECLARE books_cursor CURSOR FOR

SELECT title, quantity FROM books;

DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

118

CITS : IT & ITES - कं ूटर सॉ वेयर ए ीके शन - अ ास 36