Stored Procedures and Triggers

Creating a Stored Procedure

DELIMITER //
CREATE PROCEDURE GetUser(IN userId INT)
BEGIN
    SELECT * FROM users WHERE id = userId;
END //
DELIMITER ;

This procedure retrieves user details based on userId.

Creating a Trigger

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

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