DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`SP_TEST`$$
CREATE PROCEDURE `lsos_prod`.`SP_TEST`()
BEGIN
DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
-- 在这里如何获取到错误码(1054)和错误信息(Unknown column 'user_name' in 'field list')?
END; /*
* 这里degug表不存在'user_name'字段, 所以这里会如下错误:
* Error Code : 1054
* Unknown column 'user_name' in 'field list'
*/
SELECT id ,user_name FROM debug;
END$$
DELIMITER ;
DROP PROCEDURE IF EXISTS `test`.`SP_TEST`$$
CREATE PROCEDURE `lsos_prod`.`SP_TEST`()
BEGIN
DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
-- 在这里如何获取到错误码(1054)和错误信息(Unknown column 'user_name' in 'field list')?
END; /*
* 这里degug表不存在'user_name'字段, 所以这里会如下错误:
* Error Code : 1054
* Unknown column 'user_name' in 'field list'
*/
SELECT id ,user_name FROM debug;
END$$
DELIMITER ;
or
SHOW WARNINGS
^^