[sqlite] Select into outfile C API

2012-06-05 Thread patrick
Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? I see the sqlite3 binary has an interactive .output parameter. Anything similar in the C API? TIA Pat... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8

Re: [sqlite] Select into outfile C API

2012-06-04 Thread Igor Tandetnik
On 6/4/2012 3:48 PM, Patrick wrote: Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? No. But in your C program, you can always write code that reads results from SQLite, then writes them to a file in the format of your choice. I see the sqlite3 binary has an interact

Re: [sqlite] Select into outfile C API

2012-06-04 Thread Simon Slavin
On 4 Jun 2012, at 8:48pm, Patrick wrote: > Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? > I see the sqlite3 binary has an interactive .output parameter. Anything > similar in the C API? Nope. Sorry. You have to write your own C code to output to a file. The '.o

[sqlite] Select into outfile C API

2012-06-04 Thread Patrick
Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API? I see the sqlite3 binary has an interactive .output parameter. Anything similar in the C API? TIA Pat... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8