[HELP] MYSQL - execute

[itHyperoX]

Hi, how can i get the inserted id?

local insert = mysql:execute("INSERT INTO lifts (outX, outY , outZ, inX, inY, inZ, Name, outInterior, outDimension, inInterior, inDimension) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", X, Y, Z, inX, inY, inZ, interiorName, currentInterior, currentDimension, interior, dimension)

outputChatBox(tostring(insert.LiftID))

Debug: Boolean value.

Edited May 31, 2018 by TheMOG

[itHyperoX]

Also what's the problem with this ? I don't  need code, just a help!

addEventHandler("onResourceStart", root, function()
    local result = mysql:singleQuery("SELECT * FROM markers")
    for k, v in pairs(result) do
        outputChatBox(tonumber(v["outX"]).. tonumber(v["outY"]).. tonumber(v["outZ"]))
    end

end)

Debug : attempt to concatenate a nil value

[itHyperoX]

up