title: LuaSQLite - reading a single entry
body: <p>I would like to read a single entry from sqlite-database with <a href="http://lua.sqlite.org/index.cgi/index" rel="nofollow">LuaSQLite3</a> and not all rows.</p>
  
  <pre><code>local sqlite3 = require("lsqlite3")
  
  local db = sqlite3.open_memory()
  
  db:exec[[
    CREATE TABLE test (id INTEGER PRIMARY KEY, content);
  
    INSERT INTO test VALUES (NULL, 'Hello World');
    INSERT INTO test VALUES (NULL, 'Hello Lua');
    INSERT INTO test VALUES (NULL, 'Hello Sqlite3')
  ]]
  
  for row in db:nrows("SELECT * FROM test") do
    print(row.id, row.content)
  end
  </code></pre>