jh:

  IF address_count != 1 THEN      SIGNAL SQLSTATE '45000'     SET MESSAGE_TEXT = 'address_id not found in address table.';   END IF;

 

jh:

mysql 里面存储过程报错的方法。 45000 错误号，后面是消息。

 

jh:

前台可以直接显示MESSAGE_TEXT里面的消息

Created with the Personal Edition of HelpNDoc: Free Web Help generator