sky_phone-sky-systems/.agents/skills/oxmysql/insert.md

insert

Inserts a row and returns the insert id (or nil/falsy on failure).

Lua (Promise)

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

Lua (Callback)

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

JavaScript

const insertId = await MySQL.insert('INSERT INTO `users` (identifier, firstname, lastname) VALUES (?, ?, ?)', [identifier, firstName, lastName]);

Reference: insert – coxdocs.dev.