Revision Difference
sql.Query#512884
<function name="Query" parent="sql" type="libraryfunc">⤶
<description>Performs a query on the local SQLite database, returns a table as result set, nil if result is empty and false on error.</description>⤶
<realm>Shared and Menu</realm>⤶
<args>⤶
<arg name="query" type="string">The query to execute.</arg>⤶
</args>⤶
<rets>⤶
<ret name="" type="table">false is returned if there is an error, nil if the query returned no data.</ret>⤶
</rets>⤶
</function>⤶
⤶
<example>⤶
<description>Functions that are examples of saving and creating information into the database.</description>⤶
<code>⤶
function CreateTable()⤶
sql.Query("CREATE TABLE player_data(SteamID TEXT, Money INTEGER)")⤶
end⤶
⤶
function NewPlayerToDataBase(ply)⤶
sql.Query("INSERT INTO player_data(SteamID, Money) VALUES('"..ply:SteamID().."', 0)")⤶
end⤶
⤶
function SavePlayerToDatabase(ply, Money)⤶
sql.Query("UPDATE player_data SET Money="..Money.." WHERE SteamID='"..ply:SteamID().."'")⤶
end⤶
</code>⤶
⤶
</example>
Garry's Mod
Rust
Steamworks
Wiki Help
S&box