summaryrefslogtreecommitdiffstats
path: root/Doc/lib/libsqlite3.tex
diff options
context:
space:
mode:
Diffstat (limited to 'Doc/lib/libsqlite3.tex')
-rw-r--r--Doc/lib/libsqlite3.tex6
1 files changed, 6 insertions, 0 deletions
diff --git a/Doc/lib/libsqlite3.tex b/Doc/lib/libsqlite3.tex
index 19eed7e..a7a0e94 100644
--- a/Doc/lib/libsqlite3.tex
+++ b/Doc/lib/libsqlite3.tex
@@ -42,6 +42,12 @@ c.execute('''create table stocks
# Insert a row of data
c.execute("""insert into stocks
values ('2006-01-05','BUY','RHAT',100,35.14)""")
+
+# Save (commit) the changes
+conn.commit()
+
+# We can also close the cursor if we are done with it
+c.close()
\end{verbatim}
Usually your SQL operations will need to use values from Python