diff options
Diffstat (limited to 'Doc/includes/sqlite3/execsql_fetchonerow.py')
| -rw-r--r-- | Doc/includes/sqlite3/execsql_fetchonerow.py | 19 |
1 files changed, 0 insertions, 19 deletions
diff --git a/Doc/includes/sqlite3/execsql_fetchonerow.py b/Doc/includes/sqlite3/execsql_fetchonerow.py deleted file mode 100644 index 0ca7e14..0000000 --- a/Doc/includes/sqlite3/execsql_fetchonerow.py +++ /dev/null @@ -1,19 +0,0 @@ -import sqlite3 - -con = sqlite3.connect("mydb") - -cur = con.cursor() -SELECT = "select name, first_appeared from people order by first_appeared, name" - -# 1. Iterate over the rows available from the cursor, unpacking the -# resulting sequences to yield their elements (name, first_appeared): -cur.execute(SELECT) -for name, first_appeared in cur: - print(f"The {name} programming language appeared in {first_appeared}.") - -# 2. Equivalently: -cur.execute(SELECT) -for row in cur: - print(f"The {row[0]} programming language appeared in {row[1]}.") - -con.close() |