MYsql 存储过程简单语法

CREATE PROCEDURE `p1`(
IN id INT UNSIGNED,
IN name VARCHAR(11)
)
BEGIN
  lable_exit: BEGIN
    SET @SqlCmd = 'SELECT * FROM tA ';
    IF id IS NOT NULL THEN

         SET @SqlCmd = CONCAT(@SqlCmd , 'WHERE id=?');
         PREPARE stmt FROM @SqlCmd;
         SET @a = id;
         EXECUTE stmt USING @a;
         LEAVE lable_exit;
    END IF;
    IF name IS NOT NULL THEN
         SET @SqlCmd = CONCAT(@SqlCmd , 'WHERE name LIKE ?');
         PREPARE stmt FROM @SqlCmd;
         SET @a = CONCAT(name, '%');
         EXECUTE stmt USING @a;
         LEAVE lable_exit;    
    END IF;
  END lable_exit;
END;

CALL `p1`(1,NULL);
CALL `p1`(NULL,'QQ');

DROP PROCEDURE `p1`;