如何在mysql中使用存储过程执行SQL

DELIMITER //
CREATE PROCEDURE 存储过程名(参数列表)
BEGIN
    -- SQL语句
END //
DELIMITER ;

DELIMITER //
CREATE PROCEDURE GetUsers()
BEGIN
    SELECT id, name, email FROM users;
END //
DELIMITER ;

DELIMITER //
CREATE PROCEDURE GetUserById(IN user_id INT)
BEGIN
    SELECT id, name, email FROM users WHERE id = user_id;
END //
DELIMITER ;

CALL GetUserById(1);

DELIMITER //
CREATE PROCEDURE GetUserCount(OUT total INT)
BEGIN
    SELECT COUNT(*) INTO total FROM users;
END //
DELIMITER ;

CALL GetUserCount(@user_count);
SELECT @user_count;

DELIMITER //
CREATE PROCEDURE CountRows(IN tbl_name VARCHAR(50), OUT row_count INT)
BEGIN
    SET @sql = CONCAT('SELECT COUNT(*) INTO @cnt FROM ', tbl_name);
    PREPARE stmt FROM @sql;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
    SET row_count = @cnt;
END //
DELIMITER ;

CALL CountRows('users', @total);
SELECT @total;

SHOW PROCEDURE STATUS WHERE Db = 'your_database_name';
-- 或查看具体定义
SHOW CREATE PROCEDURE 存储过程名;

DROP PROCEDURE IF EXISTS 存储过程名;