add hg and python

1 files changed, 13 insertions, 0 deletions

diff --git a/sys/src/cmd/python/Doc/lib/sqlite3/execsql_printall_1.py b/sys/src/cmd/python/Doc/lib/sqlite3/execsql_printall_1.py
new file mode 100644
index 000000000..d27d735a2
--- /dev/null
+++ b/sys/src/cmd/python/Doc/lib/sqlite3/execsql_printall_1.py
@@ -0,0 +1,13 @@
+import sqlite3
+
+# Create a connection to the database file "mydb":
+con = sqlite3.connect("mydb")
+
+# Get a Cursor object that operates in the context of Connection con:
+cur = con.cursor()
+
+# Execute the SELECT statement:
+cur.execute("select * from people order by age")
+
+# Retrieve all rows as a sequence and print that sequence:
+print cur.fetchall()