Rechercher dans le manuel MySQL
28.7.7.14 mysql_errno()
unsigned int mysql_errno(MYSQL *mysql)
Description
For the connection specified by mysql
,
mysql_errno()
returns the
error code for the most recently invoked API function that can
succeed or fail. A return value of zero means that no error
occurred. Client error message numbers are listed in the MySQL
errmsg.h
header file. Server error
message numbers are listed in
mysqld_error.h
. Errors also are listed at
Appendix B, Errors, Error Codes, and Common Problems.
Some functions such as
mysql_fetch_row()
do not set
mysql_errno()
if they
succeed. A rule of thumb is that all functions that have to
ask the server for information reset
mysql_errno()
if they
succeed.
MySQL-specific error numbers returned by
mysql_errno()
differ from
SQLSTATE values returned by
mysql_sqlstate()
. For example,
the mysql client program displays errors
using the following format, where 1146
is
the mysql_errno()
value and
'42S02'
is the corresponding
mysql_sqlstate()
value:
An error code value for the last
mysql_
call, if it failed. zero means no error occurred.
xxx
()
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-mysql-errno.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.