hello keith, sqlite -echo test.sqlite < test44.sql > test44.out 2>&1 is the correct command for redirecting. I want on which query i got this error. My queries are in test44.sql.
Thanks, varun Sent with MailTrack <https://mailtrack.io/install?source=signature&lang=en&referral=varunkaja.1...@gmail.com&idSignature=22> On 27 June 2016 at 15:55, Keith Medcalf <kmedc...@dessus.com> wrote: > > Standard computer stuff, operating system independant: > > You forgot to redirect handle 2 (stderr) to handle 1 (stdout) > > sqlite -echo test.sqlite < test44.sql 2>&1 > test44.out > > > -----Original Message----- > > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > > boun...@mailinglists.sqlite.org] On Behalf Of Kaja Varunkumar > > Sent: Monday, 27 June, 2016 05:28 > > To: sqlite-users@mailinglists.sqlite.org > > Subject: [sqlite] Regarding redirecting SQL results and errors to a > single > > output file. > > > > Hello, > > > > sqlite -echo test.sqlite < test44.sql > test44.out. > > When I am running above command in windows command prompt, succeed query > > redirected to test44.out and errors are displayed on the command prompt. > > Here I want all the succeed and failed queries in one file. > > > > *EXAMPLE :-* > > C:\Users\vkaja\Desktop\testing_mysql>sqlite -echo test.sqlite < > > test44.sql > > > ./output/test44.out > > Error: near line 13: no such function: log_file_check > > Error: incomplete SQL: exit > > > > *In test.out :-* > > --include mkemp.txt > > --Join Select > > --General > > > > SELECT E.*, D.DNAME FROM EMP E, DEPT D WHERE E.EMPNO = 102 AND E.DEPTNO = > > D.DEPTNO; > > 102|NAME2|TITLE2|1958-02-02 02:02:02||20000.0|1|Software > > 102|NAME2|ASSISTANT||||1|Software > > --Support table aliases > > SELECT E.ENAME AS EMP_NAME, D.DNAME AS DEPT_NAME FROM EMP E, DEPT D > WHERE > > E.DEPTNO = D.DEPTNO; > > NAME1|Software > > NAME2|Software > > NAME3|Sales > > NAME4|Software > > NAME5|Sales > > NAME6|Software > > NAME7|Software > > NAME8|Marketing > > NAME9|Marketing > > NAME1|Software > > NAME2|Software > > NAME3|Sales > > NAME4|Software > > NAME5|Sales > > NAME6|Software > > NAME7|Software > > NAME8|Marketing > > NAME9|Marketing > > > > -- Select With Order By > > SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.HIREDATE, EMP.SAL, EMP.COMM, > > EMP.DEPTNO FROM DEPT DEPT, EMP EMP ORDER BY EMP.EMPNO, EMP.HIREDATE; > > 10|Jack|ASSISTANT||||100 > > 10|Jack|ASSISTANT||||100 > > 10|Jack|ASSISTANT||||100 > > 10|Jack|ASSISTANT||||100 > > 10|Jack|ASSISTANT||||100 > > 10|Jack|ASSISTANT||||100 > > 102|NAME2|ASSISTANT||||1 > > 102|NAME2|ASSISTANT||||1 > > 102|NAME2|ASSISTANT||||1 > > 102|NAME2|TITLE2|1958-02-02 02:02:02||20000.0|1 > > 102|NAME2|TITLE2|1958-02-02 02:02:02||20000.0|1 > > 102|NAME2|TITLE2|1958-02-02 02:02:02||20000.0|1 > > 103|NAME3|ASSISTANT||||2 > > 103|NAME3|ASSISTANT||||2 > > 103|NAME3|ASSISTANT||||2 > > 103|NAME3|TITLE3|1997-03-12 08:09:54||1000.5|2 > > 103|NAME3|TITLE3|1997-03-12 08:09:54||1000.5|2 > > 103|NAME3|TITLE3|1997-03-12 08:09:54||1000.5|2 > > 104|NAME4|ASSISTANT||||1 > > 104|NAME4|ASSISTANT||||1 > > 104|NAME4|ASSISTANT||||1 > > 104|NAME4|TITLE4|1997-04-02 00:00:00||2.22|1 > > 104|NAME4|TITLE4|1997-04-02 00:00:00||2.22|1 > > 104|NAME4|TITLE4|1997-04-02 00:00:00||2.22|1 > > 105|NAME5|ASSISTANT||||2 > > 105|NAME5|ASSISTANT||||2 > > 105|NAME5|ASSISTANT||||2 > > 105|NAME5|TITLE5|1997-06-12 08:09:54||1000.5|2 > > 105|NAME5|TITLE5|1997-06-12 08:09:54||1000.5|2 > > 105|NAME5|TITLE5|1997-06-12 08:09:54||1000.5|2 > > 106|NAME6|ASSISTANT||||1 > > 106|NAME6|ASSISTANT||||1 > > 106|NAME6|ASSISTANT||||1 > > 106|NAME6|TITLE6|1997-06-12 02:02:02||2.22|1 > > 106|NAME6|TITLE6|1997-06-12 02:02:02||2.22|1 > > 106|NAME6|TITLE6|1997-06-12 02:02:02||2.22|1 > > 107|NAME7|ASSISTANT||||1 > > 107|NAME7|ASSISTANT||||1 > > 107|NAME7|ASSISTANT||||1 > > 107|NAME7|TITLE7|1997-06-22 02:02:02||20000.0|1 > > 107|NAME7|TITLE7|1997-06-22 02:02:02||20000.0|1 > > 107|NAME7|TITLE7|1997-06-22 02:02:02||20000.0|1 > > 108|NAME8|ASSISTANT||||3 > > 108|NAME8|ASSISTANT||||3 > > 108|NAME8|ASSISTANT||||3 > > 108|NAME8|TITLE8|1997-07-12 08:09:54||2000.5|3 > > 108|NAME8|TITLE8|1997-07-12 08:09:54||2000.5|3 > > 108|NAME8|TITLE8|1997-07-12 08:09:54||2000.5|3 > > 109|NAME9|ASSISTANT||||3 > > 109|NAME9|ASSISTANT||||3 > > 109|NAME9|ASSISTANT||||3 > > 109|NAME9|TITLE9|2010-07-20 02:02:02||2.22|3 > > 109|NAME9|TITLE9|2010-07-20 02:02:02||2.22|3 > > 109|NAME9|TITLE9|2010-07-20 02:02:02||2.22|3 > > 110|NAME1|ASSISTANT||||1 > > 110|TEMP|ASSISTANT||||4 > > 110|NAME1|ASSISTANT||||1 > > 110|TEMP|ASSISTANT||||4 > > 110|NAME1|ASSISTANT||||1 > > 110|TEMP|ASSISTANT||||4 > > 110|NAME1|TITLE1|1990-02-02 02:02:02||2000.9|1 > > 110|NAME1|TITLE1|1990-02-02 02:02:02||2000.9|1 > > 110|NAME1|TITLE1|1990-02-02 02:02:02||2000.9|1 > > 110|TEMP|ASSISTANT|2010-07-20 02:02:02|||4 > > 110|TEMP|ASSISTANT|2010-07-20 02:02:02|||4 > > 110|TEMP|ASSISTANT|2010-07-20 02:02:02|||4 > > > > -- check the log file > > > > Thanks, > > varun > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
