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
