Posted to tcl by crshults at Sat Nov 09 07:01:37 GMT 2013view pretty
package require sqlite3
sqlite3 db test.sqlite
db eval {CREATE TABLE t1(a int, b text)}
db eval {INSERT INTO t1 VALUES (1, 'hello')}
db eval {INSERT INTO t1 VALUES (2, 'goodbye')}
db eval {SELECT * FROM t1}
db eval {SELECT * FROM t1} values {parray values}