Modules/MTA-MySQL/mysql errno

From Multi Theft Auto: Wiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.


Package-x-generic.png This function is provided by the external module MTA-MySQL. You must install this module to use this function.

Returns the last error number of a MySQL connection.

Syntax

int mysql_errno ( MySQLConnection handler )

Required arguments

  • handler: A valid MySQL link

Returns

The last error number, zero if nothing failed. Visit http://dev.mysql.com/doc/refman/5.0/en/error-handling.html for a list of error codes.

Example

Example 1: This example sends a query to the server and if it fails, shows the reason. 

result = mysql_query(handler, "SELECT FROM table") -- We have a syntax error in the query
if (not result) then -- The query failed
  outputDebugString("mysql_query failed: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler)) -- Show the reason
else
  mysql_free_result(result) -- Free the last query result data
end

See also

Retrieved from "https://wiki.multitheftauto.com/wiki/Modules/MTA-MySQL/mysql_errno?oldid=53004"