Functions
query

Query

When selecting data, returns all matching rows and columns; otherwise, returns data like insertId, affectedRows, etc.

Promise

local response = MySQL.query.await('SELECT `firstname`, `lastname` FROM `users` WHERE `identifier` = ?', {
    identifier
})
 
if response then
    for i = 1, #response do
        local row = response[i]
        print(row.firstname, row.lastname)
    end
end

Aliases

  • MySQL.Sync.fetchAll
  • exports.ghmattimysql.execute
  • exports.oxmysql.query_async

Callback

MySQL.query('SELECT `firstname`, `lastname` FROM `users` WHERE `identifier` = ?', {
    identifier
}, function(response)
    if response then
        for i = 1, #response do
            local row = response[i]
            print(row.firstname, row.lastname)
        end
    end
end)

Aliases

  • MySQL.Async.fetchAll
  • exports.ghmattimysql.execute
  • exports.oxmysql.query