View source for DbExec

__NOTOC__
{{Server function}}
{{New feature|3.0120|1.2| 
'''Available only in MTA SA 1.1.1 r3341 and onwards'''
}}
This function executes a database query using the supplied connection. No result is returned.

==Syntax== 
<syntaxhighlight lang="lua">
bool dbExec ( element databaseConnection, string query [, var param1 [, var param2 ...]] )
</syntaxhighlight>

===Required Arguments===
*'''databaseConnection:''' A database connection element previously returned from [[dbConnect]]
*'''query:''' An SQL query. Positions where parameter values will be inserted are marked with a '''?'''

===Optional Arguments===
*'''paramX:''' A variable number of parameters. These must be strings or numbers - it is important to make sure they are of the correct type. Also, the number of parameters passed must be equal to the number of '''?''' characters in the query string.
String parameters are automatically quoted and escaped as required. (If you do not want a string quoted, use '''??''')

===Returns===
Returns ''true'' unless the connection is incorrect, in which case it returns ''false''.

==Example==
This example executes an INSERT query:
<syntaxhighlight lang="lua">
dbExec( connection, "INSERT INTO table_name VALUES (?,?,?)", "aaa", "bbb", 10 )
</syntaxhighlight>


This example shows how to use '''??''' for parts of the query that are not column values:
<syntaxhighlight lang="lua">
dbExec( connection, "SELECT * FROM ?? WHERE ??=?", tableName, columnName, columnValue )
</syntaxhighlight>

==Requirements==
{{Requirements|1.1.1-9.03341|n/a}}

==See Also==
{{Registry_functions}}