query

Quando dados são selecionados, retorna todas as linhas e colunas correspondentes; caso contrário, retorna dados como 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

const response = await MySQL.query('SELECT `firstname`, `lastname` FROM `users` WHERE `identifier` = ?', [
  identifier
])

if (response) {
  response.forEach((row) => {
    console.log(row.identifier, row.firstname, row.lastname)
  })
}

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)

MySQL.query('SELECT `firstname`, `lastname` FROM `users` WHERE `identifier` = ?', [
  identifier
], (response) => {
  if (response) {
    response.forEach((row) => {
      console.log(row.firstname, row.lastname)
    })
  }
})

Aliases

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

Promise

Callback

On this page