Returns the ID of the last row that was inserted into the database.

Syntax

DB.LastInsertId()

Arguments

No arguments.

Return Values

(number): The ID of the last row that was inserted into the database. If no rows have been inserted, this will return 0.

Examples

DB.Execute([[
    INSERT INTO users (username, password_hash, operator)
    VALUES (@username, @password_hash, 1);
]],
{
    username = "maz_likes_eggs",
    password_hash = Cryptography.SHA256("super_secure_password")
})

local lastId = DB.LastInsertId()
print(lastId) -- Outputs: 1 (example output, will vary based on the actual last inserted ID)