Modules/MTA-MySQL/mysql null - Revision history

Alberto Alonso at 18:08, 5 January 2011

2011-01-05T18:08:28Z

← Older revision		Revision as of 18:08, 5 January 2011
Line 1:		Line 1:
			<pageclass class="#AA7592" subcaption="MTA-MySQL Module"></pageclass>
	__NOTOC__		__NOTOC__
	{{ModuleFunction\|MTA-MySQL}}		{{ModuleFunction\|MTA-MySQL}}

Ryden at 18:04, 14 January 2008

2008-01-14T18:04:32Z

← Older revision		Revision as of 18:04, 14 January 2008
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{ModuleFunction\|MTA-MySQL}}
	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.		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.

Ryden: New page: NOTOC 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_nu...

2008-01-14T17:26:53Z

New page: __NOTOC__ 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_nu...

New page

__NOTOC__
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==
<syntaxhighlight lang="lua">
MySQLNullValue mysql_null ( )
</syntaxhighlight>

===Returns===
A MySQL NULL type.

===Example===
'''Example 1:''' This example checks if the name of an account is null.
<syntaxhighlight lang="lua">
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
</syntaxhighlight>

==See also==
{{Modules/MTA-MySQL/Result_functions}}

Modules/MTA-MySQL/mysql null - Revision history

Alberto Alonso at 18:08, 5 January 2011

Ryden at 18:04, 14 January 2008

Ryden: New page: __NOTOC__ 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_nu...

Ryden: New page: NOTOC 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_nu...