icMySQL
Functions
MySQL
Query

Query

The query function is to query data in the specified table of the database.

Params

  • Database ID (OPTIONAL) is to specify for what database is the query to. By default it take DB#1 you can change the default DB in the config.js.
  • Query(*) the query to execute.
  • Values(OPTIONAL) the values that will be replaced in the query, these are ?, @, :, etc.
  • Function(OPTIONAL) is the function that will be executed when the query is finished.
  • Cache(OPTIONAL) is to specify if the query want to use the cache system, by default is activated this only may be disabled if there're problems with the cache system.

Return

If you've specified a function it will return the result of the query in the function, if not it will return the result of the query. In this case it will return all the data matched.

Functions

exports["ice_mysql"]:Query(database, query, values, function, cache)
exports["ice_mysql"]:AwaitQuery(database, query, values, function, cache)

Use

Awaitable

local result = MySQL.AwaitQuery(1, "SELECT name FROM players WHERE id=@id", {
    ["@id"] = 3
})

Callback

  • Callback will return the same as the awaitable function but in the callback function.
  • If the callback is not provided it will return the same as the awaitable function.
  • If you want to make the query to execute in the main thread you have to specify a simple function like this: () => {} to do anything depending on the language.
MySQL.Query(1, "SELECT name FROM players WHERE id=@id", {
    ["@id"] = 3
}, function(result)
    print(result)
end)
PrepareSingle