diff options
| author | Miss Islington (bot) <31488909+miss-islington@users.noreply.github.com> | 2021-05-19 07:43:44 (GMT) |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-05-19 07:43:44 (GMT) |
| commit | db20afe6c43ad585577589131bf658ce7ebe6bd2 (patch) | |
| tree | 0e29f0bf5d7c2cb4466b883972050a21303ea596 /Doc/includes/sqlite3/createdb.py | |
| parent | 76ed53ca7bf0d4a43099d9401af5fe9f75689885 (diff) | |
| download | cpython-db20afe6c43ad585577589131bf658ce7ebe6bd2.zip cpython-db20afe6c43ad585577589131bf658ce7ebe6bd2.tar.gz cpython-db20afe6c43ad585577589131bf658ce7ebe6bd2.tar.bz2 | |
bpo-44106: Improve sqlite3 example database contents (GH-26027)
(cherry picked from commit 92d1064727d6b7f4136f9c09ab52ae15e3676afe)
Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>
Diffstat (limited to 'Doc/includes/sqlite3/createdb.py')
| -rw-r--r-- | Doc/includes/sqlite3/createdb.py | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/Doc/includes/sqlite3/createdb.py b/Doc/includes/sqlite3/createdb.py index ee2950b..4970212 100644 --- a/Doc/includes/sqlite3/createdb.py +++ b/Doc/includes/sqlite3/createdb.py @@ -12,15 +12,15 @@ if os.path.exists(DB_FILE): con = sqlite3.connect(DB_FILE) cur = con.cursor() cur.execute(""" - create table people + create table lang ( - name_last varchar(20), - age integer + name varchar(20), + first_appeared integer ) """) -cur.execute("insert into people (name_last, age) values ('Yeltsin', 72)") -cur.execute("insert into people (name_last, age) values ('Putin', 51)") +cur.execute("insert into lang (name, first_appeared) values ('Forth', 1970)") +cur.execute("insert into lang (name, first_appeared) values ('Ada', 1980)") con.commit() |