问题是存储过程的输入参数与表中的列名相同。这导致了模棱两可的行为。
例如：在 SET name = name ; mysql如何解析其中哪一个是param值，哪一个是列名？
我通常用前缀 IN 参数 in_ 以及 OUT 与 out_ 代码可读性和避免含糊不清的行为。

DELIMITER $$
CREATE definer=`developer`@`localhost`
PROCEDURE `update_patient`(IN `in_patient_id`  INT(11),
                           IN `in_name`        VARCHAR(45),
                           IN `in_surname`     VARCHAR(45),
                           IN `in_middle_name` VARCHAR(45),
                           IN `in_email`       VARCHAR(45),
                           IN `in_phone`       VARCHAR(45),
                           IN `in_mobile`      VARCHAR(45),
                           IN `in_address_id`  INT(11),
                           IN `in_address_no`  VARCHAR(8),
                           IN `in_id`          VARCHAR(45),
                           IN `in_dob`         date)
  NO SQL

  UPDATE patient
  SET    name = in_name,
         surname = in_surname,
         middle_name = in_middle_name,
         email = in_email,
         phone = in_phone,
         mobile = in_mobile,
         address_id = in_address_id,
         address_no = in_address_no,
         id = in_id,
         dob = in_dob
  WHERE  patient_id = in_patient_id
  LIMIT  1;

END$$
DELIMITER ;