2008/7/22 Joanne Pham <[EMAIL PROTECTED]>:
> Hi All,
> I am current using sqlite 3.5.9 and below is command to get the data from my 
> database as:
>     .output '/opt/phoenix/monitor/exportData'
>     .mode csv
>     select '#Monitored applications' , group_concat(appName) from appMapTable;
> The output is:
>     "#Monitored 
> applications","new1,nsc1,Oracle,MSSQL,Sybase,Exchange,Informix,DB2,SQLite3,MySql,nsc2,nsc3"
> but I would like to have the format below:
> #Monitored applications, 
> new1,nsc1,Oracle,MSSQL,Sybase,Exchange,Informix,DB2,SQLite3,MySql,nsc2,nsc3
> (without ")
> Can I get the output without double quote.
> Thanks,
> JP


Don't use .mode csv,

Rgds,
Simon
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to