diff options
| author | Andreas Fankhauser hiddenalpha.ch | 2024-09-23 02:24:32 +0200 |
|---|---|---|
| committer | Andreas Fankhauser hiddenalpha.ch | 2024-09-23 02:24:32 +0200 |
| commit | 4ba3f84e6e696f8ac0e543cc036b3a84263b4327 (patch) | |
| tree | bf29083a5574b531a61ec5c99becc9b34dca5c61 | |
| parent | 3b654468071e99e931b4d0e73c681ca3db35b943 (diff) | |
| download | UnspecifiedGarbage-4ba3f84e6e696f8ac0e543cc036b3a84263b4327.zip UnspecifiedGarbage-4ba3f84e6e696f8ac0e543cc036b3a84263b4327.tar.gz | |
csv example sqlite import
| -rw-r--r-- | doc/note/sqlite/sqlite.txt | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/doc/note/sqlite/sqlite.txt b/doc/note/sqlite/sqlite.txt index eeb5aac..8a79368 100644 --- a/doc/note/sqlite/sqlite.txt +++ b/doc/note/sqlite/sqlite.txt @@ -19,5 +19,9 @@ INSERT INTO "Transaction" SELECT * FROM "other"."Transaction"; ## import CSV +csv Example (no headrow): + 1;foo + 2;bar + sqlite3 foo.db -bail -cmd '.mode csv' -cmd '.separator ;' -cmd '.import foo.csv FooTable' |