Re: [sqlite] how to write line feed "\n\r" when output a txt file

On 14 mai 2012, at 21:03, Kees Nuyt wrote: > On Mon, 14 May 2012 05:41:08 +, YAN HONG YE > wrote: > […] > By the way, common lineendings are platform dependent > MS Windows: \r\n = 0x0D 0x0A = cr lf > Unix/Linux: \n= 0x0A = lf > Apple Mac: \r= 0x0D = cr >

Re: [sqlite] how to write line feed "\n\r" when output a txt file

: Monday, May 14, 2012 2:03 PM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] how to write line feed "\n\r" when output a txt file On Mon, 14 May 2012 05:41:08 +, YAN HONG YE <yanhong...@mpsa.com> wrote: >when I use : > >.output akk.txt >select * from dhq

Re: [sqlite] how to write line feed "\n\r" when output a txt file

On Mon, 14 May 2012 05:41:08 +, YAN HONG YE wrote: >when I use : > >.output akk.txt >select * from dhq where qph>0; >.output stdout > > command to write a txt file,I found no "\n\r" in the each line, Are you sure? By the way, common lineendings are platform dependent

[sqlite] how to write line feed "\n\r" when output a txt file

when I use : .output akk.txt select * from dhq where qph>0; .output stdout command to write a txt file,I found no "\n\r" in the each line , how to write "\n\r" each line in the output txt file? ___ sqlite-users mailing list sqlite-users@sqlite.org