On Tue, 19 Nov 2013 19:05:55 +0530, techi eth <[email protected]>
wrote:
>I need this often.
>
>If possible provide some hint of plugin in Linux platform.
>
>Thanks
Have a look at the sqlite3 command line tool:
sqlite3 -help
and at the .help command in that same command line tool.
Of interest are e.g. :
.separator
.mode
With .mode list , combined with SELECT and || concatenation, almost
anything can be done.
SELECT
'{"' || firstname || '"'
, '"' || lastname || '"'
, empnumber
, ....
, '"' || country || '"}'
FROM .....
I use .mode line sometimes, which is easy to postprocess,
or .mode list with .separator '\001', if the data is suitable.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
