SQLite3/Ruby FAQ

How do I do a database query? I just want an array of the rows… Use the Database#execute method. If you don’t give it a block, it will return an array of all the rows: require 'sqlite3' db = SQLite3::Database.new( "test.db" ) rows = db.execute( "select * from test" )

[sutara_lumpur]

#Ruby db.results_as_hash = true は知らなかったー

[raycy]

How do I execute multiple statements in a single string?

[IMAKADO]

詳しく書いてある。。