Modules/MTA-MySQL/mysql null

Returns a MySQL null type. MySQL NULL and lua nil are different concepts, and a table row can contain NULL values. In this case, you must check the value comparing it to mysql_null.

Syntax

MySQLNullValue mysql_null ( )

Returns

A MySQL NULL type.

Example

Example 1: This example checks if the name of an account is null.

local result = mysql_query(handler, "SELECT name FROM account WHERE id='1' LIMIT 1") -- Execute the query
if (mysql_result(result, 1, 1) == mysql_null()) then
  outputDebugString("The name of the account #1 is null")
end
mysql_free_result(result) -- Free the result

See also

• mysql_data_seek
• mysql_fetch_field
• mysql_fields
• mysql_fetch_lengths
• mysql_fetch_row
• mysql_rows
• mysql_fetch_assoc
• mysql_rows_assoc
• mysql_field_length
• mysql_field_name
• mysql_field_seek
• mysql_field_tell
• mysql_num_fields
• mysql_num_rows
• mysql_result
• mysql_free_result
• mysql_null