Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sqlite> .mode help
- Error: mode should be one OF: COLUMN csv html INSERT line list tabs tcl
- sqlite> .schema
- CREATE TABLE random_imgur (id INTEGER PRIMARY KEY, link VARCHAR);
- sqlite> SELECT * FROM random_imgur;
- 77|sU4bR
- 78|rPaQX
- 79|yaZyh
- 80|WSQOS
- 81|9thMJ
- sqlite> .mode html
- sqlite> SELECT * FROM random_imgur;
- <TR><TD>77</TD>
- <TD>sU4bR</TD>
- </TR>
- <TR><TD>78</TD>
- <TD>rPaQX</TD>
- </TR>
- <TR><TD>79</TD>
- <TD>yaZyh</TD>
- </TR>
- <TR><TD>80</TD>
- <TD>WSQOS</TD>
- </TR>
- <TR><TD>81</TD>
- <TD>9thMJ</TD>
- </TR>
- sqlite> .mode csv
- sqlite> SELECT * FROM random_imgur;
- 77,sU4bR
- 78,rPaQX
- 79,yaZyh
- 80,WSQOS
- 81,9thMJ
- sqlite> .mode INSERT nazwa_tabeli
- sqlite> SELECT * FROM random_imgur;
- INSERT INTO nazwa_tabeli VALUES(77,'sU4bR');
- INSERT INTO nazwa_tabeli VALUES(78,'rPaQX');
- INSERT INTO nazwa_tabeli VALUES(79,'yaZyh');
- INSERT INTO nazwa_tabeli VALUES(80,'WSQOS');
- INSERT INTO nazwa_tabeli VALUES(81,'9thMJ');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement