Modules/MTA-MySQL/mysql errno
From Multi Theft Auto: Wiki
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
- mysql_connect
- mysql_close
- mysql_errno
- mysql_error
- mysql_ping
- mysql_select_db
- mysql_escape_string
- mysql_affected_rows
- mysql_change_user
- mysql_get_character_set_info
- mysql_get_client_info
- mysql_get_client_version
- mysql_get_host_info
- mysql_get_proto_info
- mysql_get_server_info
- mysql_get_server_version
- mysql_hex_string
- mysql_info
- mysql_insert_id
- mysql_query
- mysql_unbuffered_query
- mysql_set_character_set
- mysql_stat
- mysql_warning_count