from http://www.devshed.com/c/a/MySQL/Error-Handling-Examples/ Error Handler Examples Here are some examples of handler declarations: If any error condition arises (other than a NOT FOUND ), continue execution after setting l_error=1 : DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET l_error=1; If any error condition arises (other than a NOT FOUND ), exit the current block or stored program after issuing a ROLLBACK statement and issuing an error message: DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; SELECT 'Error occurred
主站蜘蛛池模板:
闽清县|
苏尼特右旗|
金平|
温宿县|
曲靖市|
福建省|
小金县|
南京市|
大港区|
肇源县|
襄城县|
三穗县|
肥东县|
和林格尔县|
平遥县|
集安市|
岢岚县|
台南县|
罗江县|
博客|
昌平区|
汕头市|
栾城县|
安化县|
黄龙县|
通化县|
四子王旗|
利川市|
田林县|
娄烦县|
固镇县|
德清县|
正蓝旗|
东台市|
平湖市|
茂名市|
肥乡县|
新闻|
五大连池市|
汽车|
越西县|