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