mysql存储过程取得错误信息的方式。
GET DIAGNOSTICS CONDITION 1 @v_sqlstate=RETURNED_SQLSTATE,@v_message= MESSAGE_TEXT;
SELECT @v_sqlstate,@v_message;
凡哥,别他妈吹牛逼了
GET DIAGNOSTICS CONDITION 1 @v_sqlstate=RETURNED_SQLSTATE,@v_message= MESSAGE_TEXT;
SELECT @v_sqlstate,@v_message;