#!lua
local handleId = mysql_new("dbIP", "dbUser", "dbPassword", "dbScheme", 3306, true)
print("MySQL handle ID: " .. handleId)

if(mysql_connect(handleId) == true) then
    print("MySQL successfully connected")

    local result = mysql_query(handleId, "SELECT * FROM someTable", true)
    if(result == false) then
        local errorInt, errorStr = mysql_error(handleId)
        print("MySQL query error: " .. errorInt .. ", " .. errorStr)
    else
        for id, row in pairs(result) do
            print("Iterating row " .. id)
            for columnName, columnValue in pairs(row) do
                print(columnName .. ": " .. columnValue)
            end
        end
    end

    --Insert something now
    result = mysql_query(handleId, "INSERT INTO someTable(someColumn) VALUES(1555)", false)
    if(result == true) then
        print("Last row: " .. mysql_insert_id(handleId))
    end
end
mysql_disconnect(handleId)