Hey, I don't know if this works in SQLite the same way, but in MySQL you can do it like this:
http://dev.mysql.com/doc/refman/5.0/en/user-variables.html (Basically "prepare" an SQL statement from a string) Best, Flo On 15 May 2009, at 16:30, Stef Mientki wrote: > hello, > > to test complex queries, I want to use the command line utility ( or > an > equivalent that remembers what I type). > > Now I've a table which contains the names of a set of other tables. > In Python I can easily create the SQL string (containing the field > name) > and commit it to the database. > > Is there a way realize this in the command line ? > So I need to get the result of a query into a variable and then use > that > variable in a new query. > > thanks, > Stef Mientki > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
