On Tue, May 18, 2010 at 10:31:55AM +0800, zeal scratched on the wall:
> Dear sqlite user group,
>
> i just run a sqlstmt like:
> >>> conn=sqlite3.connect("c:/tmp/tree_db.txt")
> >>> conn.execute("select rdn, group_concat(child_rdn) as child from cm_tree
> >>> group by rdn")
> Traceback (most recent call last):
> File "<interactive input>", line 1, in <module>
> OperationalError: no such function: group_concat
>
> is there model that should be installed but i am missed?
Most likely an out-of-date SQLite library.
> by the way, i often see other guys has sqlite command mode, just like
> sqlplus,
> sqlite>
>
> but i have not seen it in my pc, could some one helps me on this tool?
That's the "sqlite3" command line tool.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Our opponent is an alien starship packed with atomic bombs. We have
a protractor." "I'll go home and see if I can scrounge up a ruler
and a piece of string." --from Anathem by Neal Stephenson
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
