Sql

From GMod Wiki

The SQL library is an interface to the SQLite engine that is built into Garry's Mod.

The syntax and usage of SQLite is very similar to MySQL.

Library Commands

sql.Begin
sql.Commit
sql.LastError
sql.Query
sql.QueryRow
sql.QueryValue
sql.SQLStr
sql.TableExists

Additional Notes

• Tutorial Series:
  • SQLite Tutorial Part 1
  • SQLite Tutorial Part 2
  • SQLite Tutorial Part 3

• Garrys Mod uses two databases to store info: garrysmod/sv.db on the server and garrysmod/cl.db on the client.

• SQLite homepage: http://www.sqlite.org

• Also, the following site has some very good explanations of the various functions you can use inside the sql.Query function.

http://w3schools.com/sql/default.asp