OxMySQL
Functions
prepare

Prepare

Prepare can be used to execute frequently called queries faster and accepts multiple sets of parameters to be used with a single query.

  • Date will not return the datestring commonly used in FiveM
  • TINYINT 1 and BIT will not return a boolean
  • You can only use ? value placeholders, ?? column placeholders and named placeholders will throw an error

Unlike rawExecute, the SELECT statement will return a column, row, or array of rows depending on the number of columns and rows selected.

Promise

local response = MySQL.prepare.await('SELECT `firstname`, `lastname` FROM `users` WHERE `identifier` = ?', {
    identifier
})
 
 
print(json.encode(response, { indent = true, sort_keys = true }))

Aliases

  • exports.oxmysql.prepare_async

Callback

MySQL.prepare('SELECT `firstname`, `lastname` FROM `users` WHERE `identifier` = ?', {
    identifier
}, function(response)
    print(json.encode(response, { indent = true, sort_keys = true }))
end)

Aliases

  • exports.oxmysql.prepare
insertquery