-- 创建简单存储过程 DELIMITER // CREATE PROCEDURE get_user_orders(IN user_id_param INT) BEGIN SELECT * FROM orders WHERE user_id = user_id_param; END // DELIMITER ; -- 调用存储过程 CALL get_user_orders(1); --
-- 创建简单存储过程 DELIMITER // CREATE PROCEDURE get_user_orders(IN user_id_param INT) BEGIN SELECT * FROM orders WHERE user_id = user_id_param; END // DELIMITER ; -- 调用存储过程 CALL get_user_orders(1); --