Hi Brandon,

Not everyone on this list has worked with Sybase.  An explanation of
@@error and @@rowcount might be helpful.

That being said, I think you want SHOW ERRORS:
http://dev.mysql.com/doc/refman/5.1/en/show-errors.html

(note there's also a SHOW WARNINGS that show you a deeper debug level:
 http://dev.mysql.com/doc/refman/5.1/en/show-warnings.html)

and the "Rows" field of SHOW TABLE STATUS:

http://dev.mysql.com/doc/refman/5.1/en/show-table-status.html

It's important to read the whole page, to find out which table types
have an exact count in the Rows field and which don't.

-Sheeri

On 12/7/05, Brandon E Hofmann <[EMAIL PROTECTED]> wrote:
>
> What is the MySQL equivalent to Sybase's @@error and @@rowcount?  I'm
> writing stored procedures where I want to log database error codes.
>
> Please let me know.
>
> Thanks,
>
> Brandon
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to