On Feb 10, 2009, at 11:26 PM, Al wrote:
> I know that all of the prgramming interfaces have the ability to
> issue a Function Call to get
> "error number for the most recently invoked MySQL function"
>
> and
>
> "the error message for the most recently invoked MySQL function"
>
>
> such as in C using " *mysql_errno()" etc.
>
> BUT
> *
> Surely there is a way to get the SAME info via a "SQL statment" or
> "function"
>
> I know one can do a
> **
>
> select @@error_count as errorcount;
>
> to get the COUNT of errors, Surely there is SOMETHING similar
> to get the latest ERROR NUMBER and latest ERROR MESSAGE,
SHOW WARNINGS might help.
http://dev.mysql.com/doc/refman/5.1/en/show-warnings.html
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
