OxMySQL
Functions
Insert

Inserts a new entry into the database and returns the insert id for the row, if valid.

Promise

local id = MySQL.insert.await('INSERT INTO `users` (identifier, firstname, lastname) VALUES (?, ?, ?)', {
    identifier, firstName, lastName
})
 
print(id)

Aliases

  • MySQL.Sync.insert
  • exports.ghmattimysql.executeSync
  • exports.oxmysql.insert_async

Callback

MySQL.insert('INSERT INTO `users` (identifier, firstname, lastname) VALUES (?, ?, ?)', {
    identifier, firstName, lastName
}, function(id)
    print(id)
end)

Aliases

  • MySQL.Async.insert
  • exports.ghmattimysql.execute
  • exports.oxmysql.insert
Using the debug UIPrepare