Modules/MTA-MySQL/mysql query - Revision history

Alberto Alonso at 17:45, 5 January 2011

2011-01-05T17:45:37Z

← Older revision		Revision as of 17:45, 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:01, 14 January 2008

2008-01-14T18:01:47Z

← Older revision		Revision as of 18:01, 14 January 2008
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{ModuleFunction\|MTA-MySQL}}
	Executes a query in the server and retreives the result.		Executes a query in the server and retreives the result.

Ryden: Changed "Important" to uppercase

2008-01-13T18:11:49Z

Changed "Important" to uppercase

← Older revision		Revision as of 18:11, 13 January 2008
Line 2:		Line 2:
	Executes a query in the server and retreives the result.		Executes a query in the server and retreives the result.

	'''~~Important~~:''' It is '''strongly''' recommended to call [[Modules/MTA-MySQL/mysql_free_result\|mysql_free_result]] after a query,		'''IMPORTANT:''' It is '''strongly''' recommended to call [[Modules/MTA-MySQL/mysql_free_result\|mysql_free_result]] after a query,
	specially if it returns some data. Query results can be automatically deleted		specially if it returns some data. Query results can be automatically deleted
	by the lua garbage collector, so if you '''forget''' to free a result it will be		by the lua garbage collector, so if you '''forget''' to free a result it will be

Ryden at 18:11, 13 January 2008

2008-01-13T18:11:22Z

← Older revision		Revision as of 18:11, 13 January 2008
Line 3:		Line 3:

	'''Important:''' It is '''strongly''' recommended to call [[Modules/MTA-MySQL/mysql_free_result\|mysql_free_result]] after a query,		'''Important:''' It is '''strongly''' recommended to call [[Modules/MTA-MySQL/mysql_free_result\|mysql_free_result]] after a query,
	specially if it returns some data. Query results can be automatically deleted by the lua garbage collector, so if you '''forget'''		specially if it returns some data. Query results can be automatically deleted
	to free a result it will be freed at some time in the future, but it doesn't know the real result data size in memory so it can		by the lua garbage collector, so if you '''forget''' to free a result it will be
	delay the memory destroying more than it should.		freed at some time in the future, but it doesn't know the real result data size
			in memory so it can delay the memory destroying more than it should.

	==Syntax==		==Syntax==

Ryden: New page: NOTOC Executes a query in the server and retreives the result. '''Important:''' It is '''strongly''' recommended to call mysql_free_result aft...

2008-01-13T18:10:31Z

New page: __NOTOC__ Executes a query in the server and retreives the result. '''Important:''' It is '''strongly''' recommended to call mysql_free_result aft...

New page

__NOTOC__
Executes a query in the server and retreives the result.

'''Important:''' It is '''strongly''' recommended to call [[Modules/MTA-MySQL/mysql_free_result|mysql_free_result]] after a query,
specially if it returns some data. Query results can be automatically deleted by the lua garbage collector, so if you '''forget'''
to free a result it will be freed at some time in the future, but it doesn't know the real result data size in memory so it can
delay the memory destroying more than it should.

==Syntax==
<syntaxhighlight lang="lua">
MySQLResult mysql_query ( MySQLConnection handler, string query )
</syntaxhighlight>
===Required arguments===
* '''handler:''' A valid MySQL link
* '''query:''' The executing query

===Returns===
In case of error this function returns nil. IF not, a MySQLResult handler. Check the MySQL result managing functions to see how to retreive the data from it.

==Example==
'''Example 1:'''
<syntaxhighlight lang="lua">
local result = mysql_query(handler, "SELECT * FROM some_table")
if (not result) then
outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
else
mysql_free_result(result) -- Freeing the result is IMPORTANT
end
</syntaxhighlight>

==See also==
===Result managing functions===
{{Modules/MTA-MySQL/Result_functions}}
===MySQL handler functions===
{{Modules/MTA-MySQL/Handler_functions}}

Modules/MTA-MySQL/mysql query - Revision history

Alberto Alonso at 17:45, 5 January 2011

Ryden at 18:01, 14 January 2008

Ryden: Changed "Important" to uppercase

Ryden at 18:11, 13 January 2008

Ryden: New page: __NOTOC__ Executes a query in the server and retreives the result. '''Important:''' It is '''strongly''' recommended to call mysql_free_result aft...

Ryden: New page: NOTOC Executes a query in the server and retreives the result. '''Important:''' It is '''strongly''' recommended to call mysql_free_result aft...