Creating Tables with Python and SQLite, no such table

Question

I'm using Python to create a table through SQLite3, I'm getting told the table has been created in the interpreter but when looking at the table in cmd, there's no such table. Here's my code:

import sqlite3 as db

conn = db.connect('test.db')
cursor = conn.cursor()
cursor.execute("create table films(title text, year text, director text)")
print("tables added")

In the interpreter I get:

>>> ================================ RESTART ================================
>>> 
tables added

But when viewing the database through SQLite in cmd I get told:

Error: no such table: films

falsetru · Accepted Answer · 2014-02-23 11:54:12Z

1

Make sure you run the script and interpreter in the same directory. Otherwise they referenece two different db files.

answered Feb 23, 2014 at 11:54

falsetru

371k69 gold badges769 silver badges659 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rocco Lucia · Accepted Answer · 2014-02-23 11:56:10Z

0

Your code just works :-) I guess there's something wrong on how you're trying to access your table:

sucre:~ rlucia$ python sqltable.py
tables added
sucre:~ rlucia$ sqlite3 test.db
SQLite version 3.8.0.2 2013-09-03 17:11:13
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> PRAGMA table_info([films]);
0|title|text|0||0
1|year|text|0||0
2|director|text|0||0
sqlite> ^D
sucre:~ rlucia$

answered Feb 23, 2014 at 11:56

Rocco Lucia

112 bronze badges

Comments

Scratchcat1 · Accepted Answer · 2017-08-04 11:55:12Z

0

You are missing conn.commit(). Therefore your new table isn't saved and the SQL viewer cannot find the table.

answered Aug 4, 2017 at 11:55

Scratchcat1

535 bronze badges

Collectives™ on Stack Overflow

Creating Tables with Python and SQLite, no such table

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related