SQLite

gto76 · gto76 · commit 21cc09f8a605 · 2020-04-29T06:00:23.000+02:00
diff --git a/README.md b/README.md
@@ -1874,12 +1874,13 @@ db.executemany('<query>', <coll_of_above>)      # Runs execute() many times.
 
 ### Example
 **In this example values are not actually saved because `'db.commit()'` is omitted!**
+
 ```python
 >>> db = sqlite3.connect('test.db')
->>> db.execute('create table t (a, b, c)')
->>> db.execute('insert into t values (1, 2, 3)')
->>> db.execute('select * from t').fetchall()
-[(1, 2, 3)]
+>>> db.execute('create table person (id integer primary key, name, height)')
+>>> db.execute('insert into person values (null, ?, ?)', ('Jean-Luc', 187))
+>>> db.execute('select * from person').fetchall()
+[(1, 'Jean-Luc', 187)]
 ``` 
 
 ### MySQL
diff --git a/index.html b/index.html
@@ -1674,10 +1674,10 @@
 
 
 <div><h3 id="example">Example</h3><p><strong>In this example values are not actually saved because <code class="python hljs"><span class="hljs-string">'db.commit()'</span></code> is omitted!</strong></p><pre><code class="python language-python hljs"><span class="hljs-meta">&gt;&gt;&gt; </span>db = sqlite3.connect(<span class="hljs-string">'test.db'</span>)
-<span class="hljs-meta">&gt;&gt;&gt; </span>db.execute(<span class="hljs-string">'create table t (a, b, c)'</span>)
-<span class="hljs-meta">&gt;&gt;&gt; </span>db.execute(<span class="hljs-string">'insert into t values (1, 2, 3)'</span>)
-<span class="hljs-meta">&gt;&gt;&gt; </span>db.execute(<span class="hljs-string">'select * from t'</span>).fetchall()
-[(<span class="hljs-number">1</span>, <span class="hljs-number">2</span>, <span class="hljs-number">3</span>)]
+<span class="hljs-meta">&gt;&gt;&gt; </span>db.execute(<span class="hljs-string">'create table person (id integer primary key, name, height)'</span>)
+<span class="hljs-meta">&gt;&gt;&gt; </span>db.execute(<span class="hljs-string">'insert into person values (null, ?, ?)'</span>, (<span class="hljs-string">'Jean-Luc'</span>, <span class="hljs-number">187</span>))
+<span class="hljs-meta">&gt;&gt;&gt; </span>db.execute(<span class="hljs-string">'select * from person'</span>).fetchall()
+[(<span class="hljs-number">1</span>, <span class="hljs-string">'Jean-Luc'</span>, <span class="hljs-number">187</span>)]
 </code></pre></div>
 
 
