user:sql_konzole
Differences
This shows you the differences between two versions of the page.
Previous revision | |||
user:sql_konzole [2014/12/18 23:10] – [Seznam všech vlastních nálezových logů do CSV souboru] mikrom | — | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== SQL konzole ====== | ||
- | SQL konzoli lze spustit z menu [[user: | ||
- | |||
- | ===== Příkazy ===== | ||
- | <WRAP round info> | ||
- | Všimněte si, že každý příkaz začíná tečkou. | ||
- | </ | ||
- | |||
- | < | ||
- | .backup ?DB? FILE Backup DB (default " | ||
- | .bail on|off | ||
- | .clone NEWDB Clone data into NEWDB from the existing database | ||
- | .databases | ||
- | .dump ?TABLE? ... Dump the database in an SQL text format | ||
- | If TABLE specified, only dump tables matching | ||
- | LIKE pattern TABLE. | ||
- | .echo on|off | ||
- | .eqp on|off | ||
- | .exit Exit this program | ||
- | .explain ? | ||
- | With no args, it turns EXPLAIN on. | ||
- | .fullschema | ||
- | .headers on|off | ||
- | .help Show this message | ||
- | .import FILE TABLE | ||
- | .indices ? | ||
- | If TABLE specified, only show indices for tables | ||
- | | ||
- | .load FILE ? | ||
- | .log FILE|off | ||
- | .mode MODE ? | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | .nullvalue STRING | ||
- | .once FILENAME | ||
- | .open ? | ||
- | .output ? | ||
- | .print STRING... | ||
- | .prompt MAIN CONTINUE | ||
- | .quit Exit this program | ||
- | .read FILENAME | ||
- | .restore ?DB? FILE | ||
- | .save FILE Write in-memory database into FILE | ||
- | .schema ? | ||
- | If TABLE specified, only show tables matching | ||
- | LIKE pattern TABLE. | ||
- | .separator STRING ?NL? Change separator used by output mode and .import | ||
- | NL is the end-of-line mark for CSV | ||
- | .shell CMD ARGS... | ||
- | .show Show the current values for various settings | ||
- | .stats on|off | ||
- | .system CMD ARGS... | ||
- | .tables ? | ||
- | If TABLE specified, only list tables matching | ||
- | LIKE pattern TABLE. | ||
- | .timeout MS Try opening locked tables for MS milliseconds | ||
- | .timer on|off | ||
- | .trace FILE|off | ||
- | .vfsname ?AUX? Print the name of the VFS stack | ||
- | .width NUM1 NUM2 ... Set column widths for " | ||
- | | ||
- | </ | ||
- | |||
- | ===== Příklady použití ===== | ||
- | Zde je několik příkladů použití. Více naleznete v sekci [[user: | ||
- | |||
- | ==== Seznam všech vlastních nálezových logů do CSV souboru ==== | ||
- | Výsledkem je CSV soubor test.csv v [[user: | ||
- | <code sql> | ||
- | sqlite> .header on | ||
- | sqlite> .mode csv | ||
- | sqlite> .once test.csv | ||
- | sqlite> SELECT id, | ||
- | sqlite> .exit | ||
- | </ | ||
user/sql_konzole.txt · Last modified: 2020/10/28 11:10 by mikrom