lua-sqlite

http://www.nessie.de/mroth/lua-sqlite3/documentation.html

디비 열기
[code]
-- Open a file database
db = sqlite3.open("filename")

-- Open a temporary database in memory
db = sqlite3.open_memory()
[/code]
디비 닫기
[code]
-- Ok
db:close()
[/code]
실행
[code]
db:exec( "CREATE TABLE test (id, data)" )
db:exec[[ INSERT INTO test VALUES (1, "Hello World") ]]
[/code]
Fetching
[code]
-- Returns a row as an integer indexed array, (배열로 받기)
for row in db:irows("SELECT * FROM test") do
print(row[1], row[2])
end

-- Returns a row as an table, indexed by column names (컬럼명으로 받기)
for row in db:rows("SELECT * FROM test") do
print(row.id, row.data)
end

-- Returns each column directly (변수로 직접 받기)
for id, data in db:cols("SELECT * FROM test") do
print(id, data)
end
[/code]