Paul DuBois wrote:
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
Indeed it will, bu if you need via a SQL QUERY to return that info, HOW
can one get
to it. I mean since I can use Straight SQL to get to the COUNT of
errors, it just seems there would HAVE to be a FUNCTION or USER_VARIABLE
that would contain this info
Has Anybody found such a way ????
THX
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org