Advertisement
Guest User

sqlite3 mode command

a guest
Jun 9th, 2014
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.92 KB | None | 0 0
  1. sqlite> .mode help
  2. Error: mode should be one OF: COLUMN csv html INSERT line list tabs tcl
  3.  
  4.  
  5. sqlite> .schema
  6. CREATE TABLE random_imgur (id INTEGER PRIMARY KEY, link VARCHAR);
  7. sqlite> SELECT * FROM random_imgur;
  8. 77|sU4bR
  9. 78|rPaQX
  10. 79|yaZyh
  11. 80|WSQOS
  12. 81|9thMJ
  13.  
  14.  
  15. sqlite> .mode html
  16. sqlite> SELECT * FROM random_imgur;
  17. <TR><TD>77</TD>
  18. <TD>sU4bR</TD>
  19. </TR>
  20. <TR><TD>78</TD>
  21. <TD>rPaQX</TD>
  22. </TR>
  23. <TR><TD>79</TD>
  24. <TD>yaZyh</TD>
  25. </TR>
  26. <TR><TD>80</TD>
  27. <TD>WSQOS</TD>
  28. </TR>
  29. <TR><TD>81</TD>
  30. <TD>9thMJ</TD>
  31. </TR>
  32.  
  33.  
  34. sqlite> .mode csv
  35. sqlite> SELECT * FROM random_imgur;
  36. 77,sU4bR
  37. 78,rPaQX
  38. 79,yaZyh
  39. 80,WSQOS
  40. 81,9thMJ
  41.  
  42.  
  43. sqlite> .mode INSERT nazwa_tabeli
  44. sqlite> SELECT * FROM random_imgur;
  45. INSERT INTO nazwa_tabeli VALUES(77,'sU4bR');
  46. INSERT INTO nazwa_tabeli VALUES(78,'rPaQX');
  47. INSERT INTO nazwa_tabeli VALUES(79,'yaZyh');
  48. INSERT INTO nazwa_tabeli VALUES(80,'WSQOS');
  49. INSERT INTO nazwa_tabeli VALUES(81,'9thMJ');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement