Wiki
Clone wikiEFLC-MP LUA / MySQL Functions
MySQL Functions
MySQL Demo
#!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)
Updated