On Thu, May 02, 2013 at 03:45:16PM +0100, Simon Slavin scratched on the wall:
> I would like the introduction of a command which changes a SELECT the
> same way EXPLAIN QUERY PLAN changes a SELECT. This one should take
> the SELECT and instead of producing a table, sometimes with many
> columns, produces a 1 column table with the SELECTed data shown
> as INSERT commands, with values correctly single-quoted where necessary.
You know the sqlite3 program already does this, right?
.mode insert
If you need the functionality built into your application, just rip
out the code and use it.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it,
but showing it to the wrong people has the tendency to make them
feel uncomfortable." -- Angela Johnson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
