-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathsqlite.html
118 lines (91 loc) · 4.87 KB
/
sqlite.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
<!DOCTYPE html>
<html lang="en" data-content_root="../">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" /><meta name="viewport" content="width=device-width, initial-scale=1" />
<title>sqlite — notes 0.1 documentation</title>
<link rel="stylesheet" type="text/css" href="../_static/pygments.css?v=03e43079" />
<link rel="stylesheet" type="text/css" href="../_static/basic.css?v=b08954a9" />
<link rel="stylesheet" type="text/css" href="../_static/alabaster.css?v=27fed22d" />
<script src="../_static/documentation_options.js?v=2709fde1"></script>
<script src="../_static/doctools.js?v=9bcbadda"></script>
<script src="../_static/sphinx_highlight.js?v=dc90522c"></script>
<link rel="index" title="Index" href="../genindex.html" />
<link rel="search" title="Search" href="../search.html" />
<link rel="next" title="elastic stuff" href="../elk/index.html" />
<link rel="prev" title="install" href="postgresql/rocky9.html" />
<link rel="stylesheet" href="../_static/custom.css" type="text/css" />
</head><body>
<div class="document">
<div class="documentwrapper">
<div class="bodywrapper">
<div class="body" role="main">
<section id="sqlite">
<h1>sqlite<a class="headerlink" href="#sqlite" title="Link to this heading">¶</a></h1>
<section id="sqlite-import-from-cli">
<h2>sqlite | import from cli<a class="headerlink" href="#sqlite-import-from-cli" title="Link to this heading">¶</a></h2>
<p>The table will need to have the same number of columns as the csv file.</p>
<div class="highlight-console notranslate"><div class="highlight"><pre><span></span><span class="go">sqlite3 --csv database.db ".import file.csv table_name"</span>
</pre></div>
</div>
</section>
</section>
</div>
</div>
</div>
<div class="sphinxsidebar" role="navigation" aria-label="Main">
<div class="sphinxsidebarwrapper">
<h1 class="logo"><a href="../index.html">notes</a></h1>
<h3>Navigation</h3>
<ul class="current">
<li class="toctree-l1 current"><a class="reference internal" href="index.html">databases</a><ul class="current">
<li class="toctree-l2"><a class="reference internal" href="sql.html">sql</a></li>
<li class="toctree-l2"><a class="reference internal" href="mysql/index.html">MySQL</a></li>
<li class="toctree-l2"><a class="reference internal" href="postgresql/index.html">PostgreSQL</a></li>
<li class="toctree-l2 current"><a class="current reference internal" href="#">sqlite</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="../elk/index.html">elastic stuff</a></li>
<li class="toctree-l1"><a class="reference internal" href="../k8s/index.html">kubernetes</a></li>
<li class="toctree-l1"><a class="reference internal" href="../openssh/index.html">OpenSSH</a></li>
<li class="toctree-l1"><a class="reference internal" href="../operating_systems/index.html">Operating Systems</a></li>
<li class="toctree-l1"><a class="reference internal" href="../ossec/index.html">OSSEC</a></li>
<li class="toctree-l1"><a class="reference internal" href="../rsyslogd/index.html">rsyslogd</a></li>
<li class="toctree-l1"><a class="reference internal" href="../ssl/index.html">ssl</a></li>
<li class="toctree-l1"><a class="reference internal" href="../stupid_unix_tricks/index.html">Stupid Unix Tricks</a></li>
<li class="toctree-l1"><a class="reference internal" href="../tools/index.html">Tools</a></li>
<li class="toctree-l1"><a class="reference internal" href="../vendor_stuff/index.html">Vendor Stuff</a></li>
<li class="toctree-l1"><a class="reference internal" href="../misc/index.html">misc</a></li>
</ul>
<div class="relations">
<h3>Related Topics</h3>
<ul>
<li><a href="../index.html">Documentation overview</a><ul>
<li><a href="index.html">databases</a><ul>
<li>Previous: <a href="postgresql/rocky9.html" title="previous chapter">install</a></li>
<li>Next: <a href="../elk/index.html" title="next chapter">elastic stuff</a></li>
</ul></li>
</ul></li>
</ul>
</div>
<search id="searchbox" style="display: none" role="search">
<h3 id="searchlabel">Quick search</h3>
<div class="searchformwrapper">
<form class="search" action="../search.html" method="get">
<input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
<input type="submit" value="Go" />
</form>
</div>
</search>
<script>document.getElementById('searchbox').style.display = "block"</script>
</div>
</div>
<div class="clearer"></div>
</div>
<!-- your html code here -->
<div class="footer">
<em>This information has a good chance of being wrong, inconsistent, out of date, or just bad. Use at your own risk.
Feel free to notify me of any issues though.</em>
</div>
</body>
</html>