====== Stored Procedures and Triggers ======


==== Creating a Stored Procedure ====

<code>
DELIMITER //
CREATE PROCEDURE GetUser(IN userId INT)
BEGIN
    SELECT * FROM users WHERE id = userId;
END //
DELIMITER ;
</code>
This procedure retrieves user details based on userId.

==== Creating a Trigger ====

<code>
CREATE TRIGGER before_insert_user
BEFORE INSERT ON users
FOR EACH ROW
SET NEW.created_at = NOW();
</code>

This trigger sets the created_at field automatically before inserting a new user.